Data Control Language Statements Flashcards Preview

70-464 Certification > Data Control Language Statements > Flashcards

Flashcards in Data Control Language Statements Deck (3)
Loading flashcards...
1

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

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

2

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

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

3

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

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