Fedor Fedor
Fedor Fedor

Reputation: 3

Grant to sys.v_$session

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

Answers (2)

outon
outon

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

Mansi Raval
Mansi Raval

Reputation: 371

You should give select_catalog_role to your schema.

Using this grant select_catalog_role to schemaname;

Upvotes: 1

Related Questions