Oracle object privileges

When learning about Oracle, you may encounter Oracle object privileges. Here we will introduce the solutions to Oracle object privileges. Here we will share with you. The Oracle Object Privilege allows the authorized user to use the schema object owned by another user in a specific way. Some privileges only apply to certain schema objects. For example, the INDEX privilege applies only to tables, while the SELECT privilege applies to tables, views, and sequences.
1. the following privileges can be individually granted, grouped in a list, or granted with the keyword ALL.
2. Be careful when using the ALL keyword. It may implicitly grant powerful privileges

Table object privileges

The following privileges are often granted and should be fully understood.
1. SELECT allows query of a specified table
2. INSERT allows you to create a new row in a specified table.
3. UPDATE allows you to modify existing rows in a specified table.
4. DELETE allows you to DELETE rows in a specified table.
5. ALTER allows you to add, modify, or rename columns in a specified table, transfer the table to another tablespace, or even rename the specified table.
6. DEBUG allows the authorizer to use a scheduler to access the PL/SQL code in any trigger on the specified table.
7. The INDEX allows the authorizer to create a new INDEX on the specified table.
8. REFERENCES allows you to create external key constraints for reference to the specified table

View object privileges
1. SELECT query specified view
2. INSERT allows you to create a new row in a specified view.
3. UPDATE allows you to modify existing rows in a specified view.
4. DELETE allows you to DELETE rows in a specified view.
5. DEBUG allows the authorizer to use a scheduler to access the PL/SQL code in any trigger on the specified view.
6. REFERENCES allows you to create external key constraints for reference to the specified view

Sequence Object Privilege
1. SELECT allows access to the current value and the next value (namely, CURRVAL and NEXTVAL)
2. ALTER allows you to modify attributes of a specified sequence.

Stored Procedures, functions, procedures, packages, and JAVA object privileges
1. DEBUG allows access to all public and private variables and types declared in the specified program. If the object is a package, it also allows access package specifications and subjects to place breakpoints in the specified program.
2. EXCUTE allows execution of specified programs. If the object is a package, any program, variable, type, oil mark, or record declared in the table specification can be accessed.

Instance
1. Grant the SELECT, INSERT, UPDATE, and DELETE privileges on the MERs table to the role SALES_MANAGER.
2. If the special user is granted the PUBLIC privilege, the privilege becomes accessible to all current and future database users. The following example allows all users to SELECT from the MERs table.
3. The "with grant option" parameter allows the grantee to continue granting the Oracle object privileges to other users. In the following example, the SELECT permission for the customers table owned by sales is granted to sales_admin, and sales_admin is also allowed to grant this permission to other users.

When the privileges obtained through the with grant option parameter are canceled, the cancellation is cascade. For example, Mary grants Zachary the select privilege on the table client, and Zachary grants this privilege to Rex. When Mary cancels the Zachary privilege, the Rex privilege is also canceled.

When user Mary obtains the same privilege from multiple users at the same time, when one of the users is canceled, Mary's privilege will not be canceled, until all users authorized by Mary are revoked. The preceding section describes Oracle object privileges.

1. Oracle DB BUFFER
2. Do you know about Oracle free data blocks?
3. Full introduction to Oracle latches
4. Introduction to Oracle Shared Pool
5. Oracle COMMIT