deleted 14 characters in body; edited tags

Source Link

edited Jun 17, 2015 at 9:59

9.4k
15
36
44

I created a new login and a new user and I mapped a database in SQL Server 2012. In the login properties in Securables, we selected permissions "deny" for "View any database" for the user to see only the specified database.

The problem is that the user does not see any database.

If I select "Grant" to "View any database", user can see all databases. How can I make the user can see only the specified database?

Thank you!

Tweeted twitter.com/#!/StackDBAs/status/393627558111350784

occurred Oct 25, 2013 at 6:38

Post Migrated Here from stackoverflow.com (revisions)

occurred Oct 24, 2013 at 13:51

Source Link

asked Oct 24, 2013 at 9:07

user2645263

Create users in SQL Server 2012

I created a new login and a new user and I mapped a database in SQL Server 2012. In the login properties in Securables, we selected permissions "deny" for "View any database" for the user to see only the specified database.

The problem is that the user does not see any database.

If I select "Grant" to "View any database", user can see all databases. How can I make the user can see only the specified database?

Thank you!

sql sql-server

Stack Exchange Network

Return to Question

Create users in SQL Server 2012