Question

How would you explain database roles and privileges in Oracle SQL security? How do you grant and revoke privileges to users and roles in Oracle?

Answer 1

Database roles are named groups of related privileges. They allow for assigning multiple privileges to a role and granting or revoking the role to users, simplifying security management. The GRANT statement is used to grant, and the REVOKE statement is used to revoke privileges.