Link to home
Start Free TrialLog in
Avatar of Netsol-NOS
Netsol-NOS

asked on

Oracle Database Access Rights

Dear EE,

We made Following changes in newly created database

--Create user
Create user ABC identified by <password>;
ALTER USER ABC DEFAULT TABLESPACE TBS_LS_DATA;
ALTER USER ABC QUOTA UNLIMITED ON TBS_LS_DATA;
ALTER USER ABC QUOTA UNLIMITED ON TBS_LS_IDX;
ALTER USER ABC TEMPORARY TABLESPACE TEMP;

grant resource,connect, CREATE VIEW, ALTER PROFILE, create session, CREATE ANY
DIRECTORY,DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION,ALTER ANY
PROCEDURE,execute any procedure to ABC;

--Grant DBA Rights to User
grant dba to ABC;

-- 4 Roles for user
GRANT EXP_FULL_DATABASE TO ABC;
GRANT CONNECT TO ABC;
GRANT RESOURCE TO ABC;
ALTER USER ABC DEFAULT ROLE ALL;

-- 2 System Privileges for user
GRANT UNLIMITED TABLESPACE TO ABC;
GRANT CREATE SESSION TO ABC;

--Revoke DBA Rights from User
revoke dba from ABC;

But when we try to insert a row in a table or create a contract using CMS application got below error (see attached file.)



PLEASE SEE ATTACHED FILES

Please confirm what other rights are required to do so.


Thanks
1Untitled.jpg
2Untitled.jpg
3Untitled.jpg
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Netsol-NOS
Netsol-NOS

ASKER

As we revoke DB rights at the end so that also revoke quota privilages that's why we get above error.