March 13, 2009 at 5:27 am
Dear all
I am trying to create database on the sql server and this database is protected by password, so that the user who has the password has access to that database...not more
how to make that..any ideas?
March 13, 2009 at 7:41 am
studying for 70-431 and there is a question about creating a database master key. sounds like something that will work for you
March 13, 2009 at 4:38 pm
You can create a SQL Login with password and grant that login access to the database. Don't grant any one access; then only people in Sysadmin and that login will be able to see the contents of the database.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 13, 2009 at 4:39 pm
SQL Noob (3/13/2009)
studying for 70-431 and there is a question about creating a database master key. sounds like something that will work for you
Database Master Key is used for encryption of data with in the database; far as I know it can't be used to restrict access.
Encryption for 2005: http://technet.microsoft.com/en-us/library/ms189586(SQL.90).aspx
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply