Application user got below error while running job. He said this job was run successfully previously.
But only today got below error. He complained about privileges issue.
Applicaton user end Error:create table: create table SNRK.C$_0MA_CNTRT with the HB_STAGING schema (SKHB)
Error is : 1031 : 42000 : java.sql.SQLException: ORA-01031: privilèges insuffisants
yesterday I was revoked the dba role from this user but still he had create session privileges on his schema.
But today my mate have granted DBA Role again and also granted insert,update,delete,drop,create any table to user.
Now apllication user said issue has resolved.My though:
DBA Role is not problem for above error and DBA role didn't resolve the issue since DBA role don't have create privileges as below.
Issue has resolved becuase my mate has given "Grant create,drop,delete,insert******* any table to user". I know Grant create**** any table to user'
is not good practice for DBA. DBA Role have below privileges:
SQL> SELECT distinct(PRIVILEGE) FROM DBA_TAB_PRIVS WHERE GRANTEE = 'DBA';
ON COMMIT REFRESH
10 rows selected.Need your input here:
Could you please let me know DBA Role has resolved the issue or privilège insert,update,delete,drop,create any table.... has resolved issue?