Last post Jan 28, 2016 10:02 AM by innocent_Developer
Jan 27, 2016 04:32 AM|innocent_Developer|LINK
I have users to access to database. I created users in login tag under security in sql server 2012.
In the property of the user > property > server roles - public
user > property > Mapping > chose specific database to access > and given db_owner and public
If i dont give db_owner to developers, they cant access to db.
I dont want them to delete dabase, schemas changes, no back up .
Jan 27, 2016 06:43 AM|Nan Yu|LINK
You could setup a database user with read-only access to the database by :
Using SQL Server Management Studio 2008:
Please refer to below article for more information :
Jan 28, 2016 10:02 AM|innocent_Developer|LINK
I tried as you mentioned.
They can logged in, but they cant view table columns
i have given db_datareader, db_datawriter