Data Control Language Statements

Question 1

What is the statement to give access to a table to a user?

Answer 1

GRANT SELECT, INSERT, UPDATE, DELETE ON [TableName] TO UserName

Question 2

What is the statement to remove access to a table to a user?

Answer 2

REVOKE SELECT, INSERT, UPDATE, DELETE ON [TableName] TO UserName

Question 3

What is the statement to make sure that a user does not have access to a table?

Answer 3

DENY SELECT, INSERT, UPDATE, DELETE ON [TableName] TO UserName