Introduction to oracle object permissions

Oracle object permission is an important part of oracle Database permission management. The following describes the oracle object permission in detail and hopes to help you.

Object permission

Oracle object permission is the right to execute special actions on objects such as tables, views, sequences, processes, functions, and packages. There are nine different types of permissions that can be granted to users or roles. See the following table:
 

Permission	ALTER	DELETE	EXECUTE	INDEX	INSERT	READ	REFERENCE	SELECT	UPDATE
Directory	No	No	No	No	No	Yes	No	No	No
Function	No	No	Yes	No	No	No	No	No	No
Procedure	No	No	Yes	No	No	No	No	No	No
Package	No	No	Yes	No	No	No	No	No	No
DB Object	No	No	Yes	No	No	No	No	No	No
Libary	No	No	Yes	No	No	No	No	No	No
Operation	No	No	Yes	No	No	No	No	No	No
Sequence	Yes	No	No	No	No	No	No	No	No
Table	Yes	Yes	No	Yes	Yes	No	Yes	Yes	Yes
Type	No	No	Yes	No	No	No	No	No	No
View	No	Yes	No	No	Yes	No	No	Yes	Yes

An object has more than one permission. special permissions can be granted or revoked. For example, TABLE's ALL permissions include:
SELECT, INSERT, UPDATE, and DELETE, as well as INDEX, ALTER, and REFERENCE.

The ALTER permission is used as an example to describe how to view the table.
ALTER permission
The alter table and lock table operations are allowed. The alter table operation can be performed as follows:

. Change table name

. Add or delete Columns

. Change the data type or size of a column.

. Convert a table into a partitioned table

The ALTER permission on SEQUENCE allows you to execute the ALTER Sequence statement and assign the minimum value, increment, and buffer size to the sequence again.
 

How to store images in oracle

Implementation of oracle tree Query

Implementation of oracle query current time

Learn more about Oracle hierarchical Query

Provides you with an in-depth understanding of Oracle temporary tables