January 4, 2005 at 9:30 am
I am new to SQL server Administration. Could someone please point me in the right direction on this.
We have a new employee and I want the person to be able to use Enterprise Manager; however, I want to make sure the new employee cannot UPDATE tables, DELETE records OR DELETE tables.
I want to make sure this new person can ONLY run SELECT statements and nothing else.
How do I do this?
January 4, 2005 at 9:50 am
There are two ways.
You can manage by individual user and by role that you construct by db. For this example I'll do it by user. Go to the user under security. Go to Database Access. Choose the database you would like to grant access to. Then below you will see choose database role. Select db_datareader and db_denydatawriter. These settings are for all tables db wide.
To get more constrictive, make on a role on the db (which then be applied to more users if needed). You can control down to specific tables from there.
hope this helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply