Hi All,
We have Oracle 11.2.0.4 on Aix 7.
I am asked to review system privileges on NON-PROD databases.
I found the four privileges 1. any privileges ( select any table ), 2.unlimited tablespace , 3.with admin option and 4. DML ( table privilegs public ) on PUBLIC 5. utl etc.
Application team/Business owner and Senior DBA accepted and asked to revoke it from the DB. I took a backup of it.
I have a doubt about 2.unlimited tablespace , 3.with admin option
For Ex : The schema scott has unlimited tablespace and create view with admin option on Development database.
1,If i revoke unlimited tablespace,what value should i give on quota to the user scott?
2,System user/One of the DBA gave "create view with admin option".I want to revoke only admin option ,not a create view privilege.
2a,revoke create view from scott with admin option;
2b,grant create view to scott;
Is it right one?
Any Suggestions
Thanks & Regards,