| 36. 9. 1. System Privileges |
|
|
A system privilege allows a user to perform certain actions within the database-such as executing DDL statements. |
Commonly Used System Privileges are |
| System Privilege | Allows You to | | CREATE SESSION | Connect to a database. | | CREATE SEQUENCE | Create a sequence. | | CREATE SYNONYM | Create a synonym. | | CREATE TABLE | Create a table. | | CREATE ANY TABLE | Create a table in any schema. | | DROP TABLE | Drop a table. | | DROP ANY TABLE | Drop a table from any schema. | | CREATE PROCEDURE | Create a stored procedure. | | EXECUTE ANY PROCEDURE | Execute a procedure in any schema. | | CREATE USER | Create a user. | | DROP USER | Drop a user. | | CREATE VIEW | Create a view. |
|