Geek asks and answers

What is the difference between the ADMIN option and the GRANT option in Oracle?

I am learning the SQL syntax for Oracle and am confronted with both the ADMIN parameter and the GRANT parameter to give users the ability to grant privileges. For example, if I want to grant SELECT privileges to SCOTT in the HR HRPLESYES table and give the opportunity to grant this access to someone else, I could do

GRANT SELECT ON HR.EMPLOYEES TO SCOTT WITH ADMIN OPTION

or

GRANT SELECT ON HR.EMPLOYEES TO SCOTT WITH GRANT OPTION.

It seems either it should work. Does anyone know what the difference is?

+3
source share
1 answer

Read it

Both the “grant” and “admin” options are used to reject centralized security controls, but they are designed for different types of privileges.

With the Grant option:

  • , .

  • , , .

  • "", , , .

:

  • , .
+2

More articles:


All Articles