From the objective of OSS-DB Exam Silver
- Operation management - basic operation management work (authority for table)
Sample Question
1.38
Choose the most appropriate explanation about table access rights.
- Only the user who owns the table (that is, the person who executed CREATE TABLE) has access to the table immediately after its creation.
- Only the owner of the table can grant the table access rights to the user.
- The owner of the table can grant or deny each user the authority to create a view based on that table.
- Despite being the owner of the table, there is no access right to the table and SELECT can not be executed.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/05/21
Answer and Explanation
In the database, access privileges such as SELECT, INSERT, UPDATE, and DELETE of the table can be managed for each user.
Use the GRANT statement to grant access authority, REVOKE statement to deprive.
In the default setting, only the owner of the table and the superuser have access rights to the table immediately after being created by CREATE TABLE, but if you change the setting with ALTER DEFAULT PRIVILEGES, the access right to the table immediately after creation It is also possible to give other users.
When granting privileges with the option of WITH GRANT OPTION at GRANT, it is possible to grant the granted privileges to other users.
In addition to SELECT, UPDATE, etc., there are authority to create foreign key constraints, authority to create triggers, etc, but there is no authority to create a view based on that table.
By default, the owner of the table has all the privileges on the table, but it is also possible to prevent access by revoking its own privileges.
Therefore the correct answer is D.