Grant/Revoke privileges on Tables
Privilages:
Select, Insert, Update, Delete, References, Alter, Index
References - Ability to create contraint that refers to table
Alter - Ability to alter table definition
Index - Ability to create index
Grant/Revoke privileges on Functions/Procedures
Privilages:
Execute
Examples:
GRANT Select, Update ON Table1 TO MyDbUser
REVOKE Select, Update ON Table1 FROM MyDbUser
GRANT Execute ON MyStoredProcedure TO MyDbUser
REVOKE Execute ON MyStoredProcedure FROM MyDbUser
Comments
Post a Comment