Explanation:
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.
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.
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.