With Grant Option

[ابوخطاب]

السلام عليكم ورحمة الله وبركاته :

برجاء من الاخوة الكرام جزاكم الله خيراتوضيح مفهوم

WITH GRANT OPTION

فمثلا لو عندنا جملة وامر كالاتي

GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION

 

اكرمكم الله

ابوخطاب

[email protected]

[Ahmad.Hasan]

السلام عليكم

1. We can grant object privileges only with grant option like (select,update,insert)

2. A--------->B--------->C
If A want to revoke privileges from C, it is not possible. The user who granted the privilege can only revoke. we have to revoke the privilege from B ,that automatically revoke the privileges from C.

ADMIN OPTION

1. We can give the system privileges onlywith admin option(CREATE TABLE,CREATE INDEX,CREATE SESSION)
2. A------>B-------->C
In admin option,it is possible to revoke the privileges from both B and C by A.Here suppose if we revoke the privileges from B means it didn’t revoke the privileges of C.

ان شاءالله يكون واضح...

موفق.