How to secure a database?
-
Hi, I want to secure a database in SQL Server 2008. Here is the situation description: I am using both 'windows' and 'sa' authentication. When I create a database (logged as 'windows' authenticated) I can see and change it (create tables, stored procedures) from logged as 'sa' authentication or vice versa. So, there is no difference whether I create it logged as 'windows' or 'sa'. But, what I need is to secure a particular database i.e. even if I am logged as 'windows' I want the particular database to be accessed only by providing a username and password. Do you have any idea how to resolve this?
-
Hi, I want to secure a database in SQL Server 2008. Here is the situation description: I am using both 'windows' and 'sa' authentication. When I create a database (logged as 'windows' authenticated) I can see and change it (create tables, stored procedures) from logged as 'sa' authentication or vice versa. So, there is no difference whether I create it logged as 'windows' or 'sa'. But, what I need is to secure a particular database i.e. even if I am logged as 'windows' I want the particular database to be accessed only by providing a username and password. Do you have any idea how to resolve this?
-
Can't be done; the Administrator of the local computer is considered to be the owner of his/her data. Alternatively, you might consider another database, or hosting your server on a different machine than the users'.
Bastard Programmer from Hell :suss:
Can you give any details (how to consider another database)?
-
Can you give any details (how to consider another database)?
-
You didn't provided solution, that is just an article of capabilities. I need short and precise guide. By the way, I don't use MySQL nor Oracle.
-
You didn't provided solution, that is just an article of capabilities. I need short and precise guide. By the way, I don't use MySQL nor Oracle.
Kujtim Hyseni wrote:
You didn't provided solution, that is just an article of capabilities.
I don't have to provide a solution. I'm not at work, this 'advice' is being given in my own spare time. I could be doing something productive, like the dishes, but I had chosen to answer this question. Might benefit someone, and I'm sure the dishes do not mind waiting :)
Kujtim Hyseni wrote:
I need short and precise guide.
You already have - it's called the documentation[^]. Right on the first lines, it states short and precise;
There are two possible modes: Windows Authentication mode and mixed mode.
Kujtim Hyseni wrote:
By the way, I don't use MySQL nor Oracle.
They were provided as alternative solutions to your problem. I'm not going to provide any further pointers, as doing the dishes seems like a more important task suddenly.
Bastard Programmer from Hell :suss:
-
Kujtim Hyseni wrote:
You didn't provided solution, that is just an article of capabilities.
I don't have to provide a solution. I'm not at work, this 'advice' is being given in my own spare time. I could be doing something productive, like the dishes, but I had chosen to answer this question. Might benefit someone, and I'm sure the dishes do not mind waiting :)
Kujtim Hyseni wrote:
I need short and precise guide.
You already have - it's called the documentation[^]. Right on the first lines, it states short and precise;
There are two possible modes: Windows Authentication mode and mixed mode.
Kujtim Hyseni wrote:
By the way, I don't use MySQL nor Oracle.
They were provided as alternative solutions to your problem. I'm not going to provide any further pointers, as doing the dishes seems like a more important task suddenly.
Bastard Programmer from Hell :suss:
Doing dishes is definitely underrated. :-D :thumbsup:
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Hi, I want to secure a database in SQL Server 2008. Here is the situation description: I am using both 'windows' and 'sa' authentication. When I create a database (logged as 'windows' authenticated) I can see and change it (create tables, stored procedures) from logged as 'sa' authentication or vice versa. So, there is no difference whether I create it logged as 'windows' or 'sa'. But, what I need is to secure a particular database i.e. even if I am logged as 'windows' I want the particular database to be accessed only by providing a username and password. Do you have any idea how to resolve this?