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

Comments

Popular posts from this blog

Tibco Rendezvous (tibrv) C# .Net example

Parse XML to dynamic object in C#