Cant execute this instruction in the database GRANT EXEC sp_configure to user

643 views Asked by At

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?

1

There are 1 answers

5
TheMadDBA On

How about this....

use master
go
GRANT EXEC [sys].[sp_configure] TO [sa-clientapp];
go