Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swathi3003
Starting Member
23 Posts |
 Posted - 2013-10-10 : 07:14:04
|
| I am bit struggling with this one Can anyone help me with this issue::::: i just want a user to see only one view in specific database(he can have select option only on specific view)..rest of all will be hide from user even systemdatabases ,logins ,another databases....how can i achieve this..even i dn't want him to see the names also.. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-10 : 08:15:29
|
| You have to DENY VIEW ANY DATABASE permission, and then grant select permission on the view on the specific database. It has been a while since I tried this, so the details are vague in my memory. There are some caveats - for example, if a user has dbo role in a database they will be able to see it etc. So please do some research and experimentation starting with this page: http://technet.microsoft.com/en-us/library/ms189077(v=sql.105).aspx |
 |
|
|
|
|
|
security