CODEWITHSUNDEEP
sqlsql-server-2012sa
Raed Alsaleh
Raed Alsaleh

Reputation: 1621

Allow only dbonwer from accessing stored procedures

I created SQL DB. and I want to allow only "DB owner" to access stored procedures. I want to prevent all other users including 'sa' user from doing that . how to do that ?

Upvotes: 0

Views: 41

Answers (1)

Paolo
Paolo

Reputation: 2254

short answer: you can't.

long answer: sa is the owner of the whole server so cannot be cut out of anything on the server. you can prevent all other users (that does not have a sysadmin role) from using the stored procedures but again you have no way to lock out sa and/or any user with sysadmin role.

you may revoke permission to SA but SA can grant these permissions back easily.

actually you may lock out SA user if you disable SQL authentication or disable the user but anyway you cannot prevent other users with sysadmin role to interact with the stored procedures: this is by design.

please post a question with the actual requirement: this question looks like a solution you are trying to implement; maybe we can help you find a suitable solution for the actual issue.

as a side note, if you don't trust the admin of the server there is something wrong...

Upvotes: 1

Related Questions