Restrict SQL Server Login access to only one database
I think this is what we like to do very much. –Step 1: (create a new user) create LOGIN hello WITH PASSWORD=’foo’, CHECK_POLICY = OFF; — Step 2:(deny view to any database) USE master; GO DENY VIEW ANY DATABASE TO hello; — step 3 (then authorized the user for that specific database , you have … Read more