sqlchild
sqlchild

Reputation: 9074

grant permission to a user to create application roles

how to grant permission to a user to create application roles? i used :

grant execute on sp_addapprole to bobDBUser , but it says :

Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.

then i changed to master database. then on executing this, it says that user bobDBUser not found. because the user was created inside bobDB, not master. so how do i do it for bobDB?

Upvotes: 1

Views: 491

Answers (1)

Aaron Digulla
Aaron Digulla

Reputation: 328614

You need to create the same user on master.

Upvotes: 3

Related Questions