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


Popular posts from this blog

Parse XML to dynamic object in C#

Parse XML to object model in C# using XSD utility