Monday, 11 February 2019
Vault : Grant object privilege to sysdba
If you enabled valut on the system and if you want to grant select on privilege to dba, it is enough to write this command :
conn hr/hr;
grant select on emp to dba;
conn yoursys/yourpasswd as sysdba;
select count(*) from emp;
(Ora-01031 ....)
conn hr/hr;
grant select on emp to yoursys;
conn yoursys/yourpasswd as sysdba;
select count(*) from emp;
(Ora-01031 ....)
In order to work, you should give this privilege to sys user;
conn hr/hr;
grant select on emp to sys;
conn yoursys/yourpasswd as sysdba;
select count(*) from emp;
ok...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment