sathyaventhan.medium.com

ORA-01031 select V$RESTORE_POINT in PL/SQL. It is a well known fact that V$RESTORE_POINT requires special handling, namely the SELECT_CATALOG_ROLE should be granted to a low-privileged user trying to access this view. ORA-01031: insufficient privileges.

  mvelikikh.blogspot.com

  coskan.wordpress.com

  minimalistic-oracle.blogspot.com

  dba.stackexchange.com

  logic.edchen.org

  support.oracle.com

  www.examtopics.com

  stackoverflow.com

SQL> alter session set events '10046 trace name context forever, level 12' * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "DEMO40.GSY_GENERAL_4", line 5 ORA-06512: at line 1.

  www.dbasupport.com

Page generated - 0.0308339596 (cbc80997eee7b429952fc524cd25296c)