Tell Me Glossary
 

Understanding Schemas, Roles and Privileges

Previous previous|next Next Page

Users need privileges to access objects in Oracle Database XE. The minimum privileges that users need are the connect and session privileges. In addition, they need system privileges that allow them to create objects. After users have created objects, they can grant privileges on their objects to other users. A group of privileges is called a role.

  • User privileges
  • Role privileges
  • System privileges

Privileges are granted by using the GRANT command. If a system privilege is granted with ADMIN OPTION, then it can be passed on by the grantee. If an object privilege is granted with GRANT OPTION, then it can be passed on.

Oracle Database XE allows Sheila to view security reports with the Utilities interface. Security reports enable Sheila to see privileges granted on database objects owned by other schemas. She can also use these reports to view database roles and system privileges grants.