Topic : User Management

What is the difference between a privilege and a role?


Answer :

A privilege is the authority to perform a certain act or command.
A role is a collection of privileges and roles that can be assigned to a user.

Show Answer Discuss

Which keyword can be used in a GRANT command to assign one or more privileges to every user in the database?


Answer :

The PUBLIC keyword can be used instead of an individual username or role in a GRANT command to assign one or more privileges to every user in the database.

Show Answer Discuss