Reputation: 9074
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