Reputation: 3
I would like to give select grant to sys.v_$session to myUser; I tried this and got error ORA-01031 "insufficient privileges"
grant select on sys.v_$session to myUser;
the problem is that I don't have access to the SYS
user (only SYSTEM)
Can I get grant to sys's table from system user?
Upvotes: 0
Views: 1679
Reputation: 116
Someone must have access to SYS.
Go and ask them to give you permission on v_$session. They must be the ones to give you read access to the system views.
There is no way to avoid it. SYS or not.
Upvotes: 0
Reputation: 371
You should give select_catalog_role to your schema.
Using this grant select_catalog_role to schemaname;
Upvotes: 1