RDBMS FUNDAMENTALS - Restricting Access to a Dat

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

RDBMS FUNDAMENTALS - Restricting Access to a Database

GRANT : This is a DCL command in SQL that you use to grant a specific set of authorities to one or more users.
Syntax : GRANT (SQL command) (column-names) ON table-name TO user-name.
REVOKE : This is a DCL command in SQL that you use to take away a specific set of authorities from one or more users.
Syntax : REVOKE (SQL command) ON table-name TO user-name.

(Continued on next question...)