Search code examples
oracle-databaseoracle12csql-grant

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?

Solution

  • You should give select_catalog_role to your schema.

    Using this grant select_catalog_role to schemaname;