A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
The correct command to grant full privileges on the table 'sales' to the new data engineering team is 'GRANT ALL PRIVILEGES ON TABLE sales TO team;'. This command provides complete control over the specified table, covering all necessary permissions for the team to fully manage the project.
Ans A : grant "privilege" on "object" object_name to <user or group>
GRANT ALL grants all privileges on "Sales" Table
A is correct as provided syntax is right
Correct answer A.