Roles in Oracle Database are designed to simplify the management of privileges. The following statements about roles are true:
B: A single user can indeed be assigned multiple roles. This allows for easy management of user privileges as they can be grouped into roles, and these roles can be granted to users.
D: A single role can be assigned to multiple users. This is one of the primary purposes of roles, to provide an efficient way to grant the same set of privileges to different users.
G: Privileges are granted to a role using the GRANT statement. This allows the role to encapsulate the privileges which can then be granted to users.
The incorrect options are:
A: Roles cannot be assigned to other roles using the ALTER ROLE statement; they are granted to other roles using the GRANT statement.
C: Roles are not assigned to users using the ALTER USER statement; roles are granted to users using the GRANT statement.
E: Privileges are not assigned to a role using the ALTER ROLE statement; they are granted using the GRANT statement.
F: A role is not limited to being assigned to just one user; it can be assigned to multiple users.
Reference:
Oracle Documentation on Roles: Database Security Guide - Roles
Oracle Documentation on the GRANT statement: SQL Language Reference - GRANT