Managing Roles   «Prev 

System Privileges Types

System privileges
System privileges

  1. CREATE TABLE: Allows a user to create, drop, and alter tables in their own schema.
  2. CREATE DATABASE LINK: Allows a user to create, drop, and alter indexes in their own schema.
  3. CREATE VIEW: Allows a user to create, drop, and alter views in their own schema.
  4. CREATE SEQUENCE: Allows a user to create, drop, and alter sequences in their own schema.
  5. CREATE PROCEDURE: Allows a user to create, drop, and alter stored procedures, stored functions, and packages in their own schema.
  6. CREATE SYNONYM: Allows a user to create, drop, and alter synonyms in their own schema.
  7. CREATE TRIGGER: Allows a user to create, drop, and alter triggers in their own schema.
  8. CREATE ANY TABLE: Allows a user to create a table in someone else's schema.
  9. ALTER ANY TABLE: Allows a user to alter someone else's table.
  10. DROP ANY TABLE: Allows a user to drop someone else's table.
  11. CREATE ANY INDEX: Allows a user to create an index in someone else's schema.
  12. ALTER ANY INDEX: Allows a user to alter someone else's index.
  13. DROP ANY INDEX: Allows a user to drop someone else's index.
  14. CREATE PUBLIC SYNONYM: Allows a user to create synonyms that affect all users.
  15. CREATE PUBLIC DATABASE LINK: Allows a user to create a publicly accessible database link.
  16. DROP PUBLIC DATABASE LINK: Allows a user to drop a public database link.
  17. DROP PUBLIC SYNONYM: Allows a user to drop a public synonym.
  18. CREATE TABLESPACE: Allows a user to create a tablespace.
  19. ALTER TABLESPACE: Allows a user to modify a tablespace definition.
  20. DROP TABLESPACE: Allows a user to drop a tablespace.
  21. CREATE ROLLBACK SEGMENT: Allows a user to create a rollback segment.
  22. ALTER ROLLBACK SEGMENT: Allows a user modify a rollback segment.
  23. ALTER DATABASE: Allows a user to issue the ALTER DATABASE command.
  24. ALTER SYSTEM: Allows a user to issue the ALTER SYSTEM command.
  25. UNLIMITED TABLESPACE: Allows a user to use any amount of space in any tablespace.