Granting and revoking object privileges
Privileges are the next level of security mechanism that can be implemented at database object level. A privilege determines the permission of performing a task on an object. A user who creates an object in the database implicitly acquires all the privileges associated with that object. Privileges can be divided into three categories:
1. Individual object privileges: Such privileges allow a user to perform different actions on the object. These privileges don't allow a user to grant or revoke similar privileges to or from other users. Example of such privileges can be:
SELECT, EXECUTE, UPDATE, and so on. Only a user withCONTROL, ACCESSCTRL, orSECADMcan grant these privileges to another user.2. CONTROL privilege: This privilege allows users to grant and revoke privileges to or from other users. The
CONTROLprivilege is implicitly granted to the creator on the newly-created tables, indexes, and packages. It is implicitly granted on newly-created...
