I have a database called sa-db
, in this database I have a user called sa-clientap
and I need to grant him permissions to execute the sp_configure
, but when I try to do this, I get an error:
Permissions on server scoped catalog views or stored procedures or extended stored procedures can be granted only when the current database is master
This is what I tried:
GRANT EXEC [sys].[sp_configure] TO [sa-clientapp]
I already tried by code and by UID but the same error pops up.
How can I make this work?
How about this....