Privileges:

The privilege is a right to execute a particular type of SQL statement or to access another user's object. Various examples of privileges involved the right to

• create a table
• select rows from another user's table
• Execute other functions, procedures etc.

Granting and Revoking System Privileges

GRANT or REVOKE is used to provide system privileges to users. The System privileges are granted to or revoked from users using the following:

The SQL commands GRANT and REVOKE

The INSERT, DELETE, UPDATE, and SELECT privileges permit the DELETE, INSERT, SELECT, and UPDATE DML operations, correspondingly on a table or view.

The INDEX, ALTER and REFERENCES privileges allow DDL operations to be performed on a table.

The one object privilege for procedures (involving standalone procedures and packages and functions) is EXECUTE. You should grant this privilege only to users who need to execute a procedure.