Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON TABLE sales TO team;
The command 'GRANT ALL PRIVILEGES ON TABLE sales TO team;' is used to grant full permissions on the specified table to a user or group. In this case, 'team' represents the new data engineering team, and 'sales' represents the table on which they need full privileges. This command covers all possible permissions, such as SELECT, INSERT, UPDATE, DELETE, etc., which are required for fully managing the table.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of an ELT (Extract, Load, Transform) project, a new data engineering team has been assembled. As part of their responsibilities, they require comprehensive control over a specific table named 'sales'. This control is necessary for them to effectively manage and perform operations related to the project. Which SQL command can be used to grant the new data engineering team full permissions on the 'sales' table?
A
GRANT ALL PRIVILEGES ON TABLE sales TO team;
B
GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
C
GRANT SELECT ON TABLE sales TO team;
D
GRANT ALL PRIVILEGES ON TABLE team TO sales;
No comments yet.