Restrict the specific user in SQL Server studio to only see the information
Hi, i want to create the new user in sql server and restrict to only one data base to deny all permission except see the table information, view, store procedure For ex : Server have 4 data base like ( Development_DB,Test_DB,Prevoius_DB, Client_DB) in case user login to user id sa on that case have to do all process Other wise user Login to new User ID Like ( Developer ) that time user have do all process to ( Development_DB,Test_DB, Previous_DB) database except Client_DB purpose is avoid the developer to modify the Current Client_DB . its only for see the client data and check the structure of function, view, and store procedure,etc... How to do this. bye nithya
Create a login for your developers, grant them db_owner rights to DevDB TestDB PrevDB. Create a role in ClientDB called ViewDefs, grant view definition to ViewDefs, grant the developer account db_datareader, db_denydatawrtier and ViewDefs access.