To grant execution to user:begin DBMS_LOCK.Sleep( 60 ); end;PLS-00201: identifier 'DBMS_LOCK' must be declared
grant execute on <object> to <user>;
sqlplus / as sysdba
grant all on sys.dbms_lock to user;
To grant execution to user:begin DBMS_LOCK.Sleep( 60 ); end;PLS-00201: identifier 'DBMS_LOCK' must be declared
grant execute on <object> to <user>;
sqlplus / as sysdba
grant all on sys.dbms_lock to user;
0 comments:
Post a Comment