|
RDBMS FUNDAMENTALS - Restricting Access to a Database
RDBMS FUNDAMENTALS Interview Questions and Answers
(Continued from previous question...)
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...)
Other Interview Questions
| 