November 4, 2013 at 12:02 am
Dear All
Need to create 3 users, please guide what roles to selected for these users
1. User who can run DDL commands
2. User who can excute procedures/views/triggers, view/add/delete/modify data
3. User who can take back up
Regards
November 4, 2013 at 4:47 am
Krishna1 (11/4/2013)
Dear AllNeed to create 3 users, please guide what roles to selected for these users
1. User who can run DDL commands
2. User who can excute procedures/views/triggers, view/add/delete/modify data
3. User who can take back up
Regards
There are built roles for this (with the exception of executing procs and funcs, etc) and they are
1. db_ddladmin
2. db_datareader and db_datawriter
3. db_backupoperator
For the following
2. User who can excute procedures
You could grant execute at the schema level but this may be overkill, a custom db role with the appropriate permissions granted might be better
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply