Sunday , June 16 2024

Grant And Revoke In Oracle

In today’s article, we will explain using Grant to authorize the user or roles and Revoke to revoke authorizations.

System and Object privileges cannot be used in the same GRANT statement.

More than one user can be authorized in the same statement.

For example,

System and object privileges cannot be given to everyone in the form of ALL statements.

For example,

Everyone can be given ALL permission on an object.

For example,

NOTE: More than one object cannot be authorized with a single GRANT.



Leave a Reply

Your email address will not be published. Required fields are marked *