Revoke execute permission from a login

Dear All,

I need to revoke execute permission from sp_configure (SP) from a user named(a) which do not exists in master database.

Regards

Mohd sufian

Why do you need/want to do this? Normal users can only use sp_configure to query the system settings; they cannot change the settings. See http://msdn2.microsoft.com/en-us/library/ms188787.aspx.

You cannot revoke the permission from a, because a is not granted the permission to EXECUTE sp_configure.

The permission to execute sp_configure is instead granted to the public role. You could revoke this one, but this is most likely not what you want, as you would then have to grant the permission explicitly to those you want to have it.

Instead, you can create the user a in the master database and explicitly DENY EXECUTE permission on sp_configure.

Thanks
Laurentiu