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
Netsol-NOSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
The quota is not for the user that is inserting the data.  The quota is for the owner of the object.  The user that owns the objects that you are inserting into in the TBS_LS_DATA tablespace has run out of quota on that tablespace.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Netsol-NOSAuthor Commented:
As we revoke DB rights at the end so that also revoke quota privilages that's why we get above error.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.