Financials for India - EBS (MOSC)

MOSC Banner

oracle atonomous Database , grant issue

In oracle atonomous Database , I have created TESTUSER  schema . Now trying to grant the below :

grant select on sys.v_$version to TESTUSER;

grant select on sys.nls_database_parameters to TESTUSER;

grant flashback any table to TESTUSER;

grant select on sys.all_coll_types to TESTUSER;

grant select on sys.all_type_attrs to TESTUSER;

grant select on sys.all_constraints to TESTUSER;

grant select on sys.all_cons_columns to TESTUSER;

encountering the  below error :

Error starting at line : 9 in command -

grant select on sys.v_$version to TESTUSER

Error report -

ORA-01031: insufficient privileges

01031. 00000 -  "insufficient privileges"

*Cause:    An attempt was made to perform a database operation without

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center