April 18, 2005 at 10:17 am
Hi,
I'm creating a db role with permissions between db_ddladmin/db_securityadmin and db_owner. Has anyone every created their own user database role or could share some experiences/insight? How do you add stored procedures (located in master db) to a new db role (located in user db) ie: sp_addrole; sp_recompile; sp_rename ...
Many thanks. Jeff
April 18, 2005 at 1:43 pm
No sure what kind of permissions do you want to grant to the database role but the magic command is "GRANT". Use it to grant all the permissions to the database role.
You can't grant sps from master database to user database role, instead, you need to create a database role in master database with all permissions and add the login into the role.
The public role is a special database role to which every database user belongs, in master database, the login may already have all necessary permissions from the public role and you may not even need to create a database role.
April 19, 2005 at 12:42 am
Agreed with Allen. There is another way to grant user permission to execute stored procedure located in master db. The user must be at least public on master. Then you click the stored proc. permissions and give particular user particular permission. Or you must create separate role in master db. It depends on you how do you decide to work out that
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply