Thursday, 12 March 2009

Add/Remove privilages from Database

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

No comments:

Post a Comment