Answer-first summary for fast verification
Answer: ALTER TABLE table_name OWNER to ‘group‘
The correct command is `ALTER TABLE table_name OWNER TO 'group_name';`. This command modifies the owner of the table to a specified group, allowing any member of the group to manage permissions. This approach enhances team collaboration and reduces dependency on a single individual for permission management. - **ALTER TABLE**: Used to change the structure or properties of an existing table. - **OWNER TO 'group_name'**: Directly transfers ownership to the specified group. Incorrect options include commands like `TRANSFER OWNER` and `GRANT OWNER`, which are not standard SQL commands for transferring ownership. The `GRANT` statement is typically used for assigning specific privileges, not ownership.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To ensure future management of table permissions by any member of a group rather than a single individual, which command should you use to transfer the ownership of tables from a departing team member to a group?
A
TRANSFER OWNER table_name to ‘group‘
B
GRANT OWNER On table_name to ‘group‘
C
ALTER TABLE table_name OWNER to ‘group‘
D
GRANT OWNER table_name to ‘group‘
E
ALTER OWNER ON table_name to ‘group‘
No comments yet.