First page Back Continue Last page Graphics
Example: DBA_SYS_PRIVS
Determine system privileges you have been granted:
Notes:
This example illustrates how to determine what system-level privileges you have been granted. Specifically, the query finds the system-level privileges held by the user ‘DAVE’ by querying the DBA_SYS_PRIVS view and applying the filter WHERE GRANTEE = ‘DAVE’. It also shows that user DAVE is not an administrator of the system privilege, meaning that this user cannot grant this privilege to other users.
As shown in this example, always use upper-case character strings when searching the data dictionary. All character strings in the dictionary are stored in upper case.
Supplemental Notes
Don’t worry, you will learn all about privileges later in this course in the lesson Managing Security. For now, here is a brief primer on privileges:
System-level privileges are privileges such as CREATE TABLE and CREATE PROCEDURE; they are not tied to one specific object.
Object-level privileges on the other hand, are tied to a specific object. For example GRANT SELECT ON CUSTOMER. Query the DBA_TAB_PRIVS to see object privileges granted on tables.