ukerandi
asked on
Sql Permission
Hi, I need to block if any one trying to create Stored Procedure and View.
even 'sa' users.
I understand it's need to be done Server Object-> Trigger.
even 'sa' users.
I understand it's need to be done Server Object-> Trigger.
Nope. You simply revoke that permissions from all users. And disable sa.
Create a role called "StoredProcedureRole" and provide CREATE PROCEDURE permission to that role.
Now assign that role to a user which you want to create stored procedures.
Now based on the roles you can allow users to perform operations..
Now assign that role to a user which you want to create stored procedures.
Now based on the roles you can allow users to perform operations..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ukerandi, a feedback will be appreciated.
Cheers.
Cheers.
ukerandi, you are also an Expert and you should know that the etiquette is to return to the opened questions and give a feedback.
Please let us know if you still need help with this question.
Cheers
Please let us know if you still need help with this question.
Cheers