Query on using ad_zd.grant_privs

[sravan]

How to grant select privilege to noetix_gbl from sys user

How to use ad_zd.grant_privs for below

ALL_SYNONYMS,
ALL_OBJECTS,
ALL_TAB_COLUMNS,
sys.obj$ o, sys.col$

[ErmanArslansOracleBlog]

ALL_* these are dictionary views and sys.obj$ or col$ these are internal sys tables.
So your request can be considered as a little weird.
Check the ALL_OBJECTS_AE and DBA_OBJECTS_AE to see the editioned objects..

AD_ZD.GRANT_PRIVS is there for not invalidating the environment while granting access to an editioned object.

Some AD_ZD.grant_privs uses cases;

An editioned code object,  actually present in the APPS schema
An effectively-editioned table (APPS Synonym -> Editioning View -> Table)

So your question and request seems a little out of scope..

[sravan]

HI Erman,

Thanks for the information provided.

Regards
Sravan