Q: 9
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?
Options
Discussion
Maybe A. Saw a similar question in a mock and it matched option A for full access.
A is right. You need
GRANT ALL PRIVILEGES ON TABLE sales TO team; to give them exactly what the question describes, full rights on the table. B only gives partial access and USAGE isn't for tables. Pretty sure about this but let me know if I'm missing something.A tbh
A , official docs and practice tests say GRANT ALL PRIVILEGES is what gives the team full control.
Has to be A for full permissions, GRANT ALL PRIVILEGES covers everything for the team on sales.
Be respectful. No spam.