June 11, 2013 at 2:25 am
Hi
Can we restrict a user from viewing a database in sql server 2012?
June 11, 2013 at 8:49 am
Yes. The login by default is a member of the public server role, which by default is granted the VIEW ANY DATABASE server permission.
If you don't want this to be the case, you can run an explicit deny against that login:-
DENY VIEW ANY DATABASE TO [YourLogin].
Following this, the login will only be able to see the master, tempdb databases along with any databases that the login owns.
More reading:- http://msdn.microsoft.com/en-us/library/ms189077.aspx
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
June 25, 2013 at 7:09 am
Are you talking about not being able to see a database within the SSMS or not being able to view the contents of a database?
June 25, 2013 at 9:34 am
Yes,not being able to view the database in ssms
June 26, 2013 at 12:20 am
kkarthik117 (6/25/2013)
Yes,not being able to view the database in ssms
In that case, Matthew has hit the nail on the head with his answer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply