June 12, 2013 at 12:36 am
Dear friend,
i want define a login in server who are dbowner of x database and can not see other databases in this server.
how can do this?
best regards,
zohreh
June 12, 2013 at 3:34 am
Hi,
Try this link could help you http://stackoverflow.com/questions/935018/hide-sql-database-from-management-studio
but see the comments, and this https://connect.microsoft.com/SQLServer/feedback/details/273830/need-view-definition-permissions-per-database
as well.
Igor Micev,My blog: www.igormicev.com
June 12, 2013 at 7:25 am
zsafakhah (6/12/2013)
Dear friend,i want define a login in server who are dbowner of x database and can not see other databases in this server.
how can do this?
best regards,
zohreh
1. Create the login if it does not already exist.
2. Deny the VIEW ANY DATABASE server-level permission from the login.
3. Create the database if it does not already exist.
4. Make the login the Database Owner of the database.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply