From the objective of OSS-DB Exam Silver
- Operation and Management - Basic operation management work (authority on table basis,
GRANT / REVOKE)
Sample Question
1.08
Please choose one that is wrong about the authority that you can allocate by the GRANT statement.
- Permission to search (SELECT) rows of a table
- The right to update (UPDATE) certain columns of the table
- Permission to delete (DELETE) all rows of a table
- Permission to delete (DROP) a table
- Permission to grant (GRANT) authority on tables to other users
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04
Answer and Explanation
The general syntax of GRANT for privileges on tables is
‘GRANT Authority type ON table name TO granted [WITH GRANT OPTION] ‘
By specifying SELECT, INSERT, UPDATE, DELETE, etc. as authority type, you can grant authority to search, insert, update and delete rows.
In SELECT / INSERT / UPDATE, search, insert and update can be allowed only for a specific column by specifying a column list between permission type and ON.
If you specify WITH GRANT OPTION at the end of the GRANT statement, you will also be given the right to grant the granted privileges to other users.
If you have the DELETE privilege you can delete all the rows in the table, but only the owner of the table will delete (DROP) the table itself, you can not grant that privilege with GRANT.
Therefore, the correct answer is D.