From the objective of OSS-DB Exam Silver
- Operation and Management - Basic operation management task (add, delete, change user)
Sample Question
1.29
Which of the following can not be changed with the ALTER USER statement? Choose one.
- Whether the user has superuser privileges
- Whether the user has the authority to newly create a user
- Whether the user has the authority to create a new table newly
- User's name
- User's password
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04
Answer and Explanation
In PostgreSQL you can change the attributes and privileges of users with ALTER USER (or ALTER ROLE). However, attributes and permissions that can be changed are limited to those that can be set at user creation in CREATE USER.
When creating a user, you can specify the name and password of the user, whether you have super user authority, whether you have authority to create users, whether you have authority to create the database, and so on. Both of these can be changed with the ALTER USER statement.
Creating a table requires the CREATE privilege for the schema, which is a privilege that can only be granted by the GRANT statement.
Therefore the correct answer is C.