Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

application is seeing times outs due to ORA-04021

Posted on 2014-03-04
3
Medium Priority
?
312 Views
Last Modified: 2014-05-19
we are seeing ORA-04021 and some objects in my schema A object is being locked by other schema Bwhich doesnt have any privs on A. how could be that possible.
where a user doesnt have privs to read/write/update the object in schema can lock that schema??
0
Comment
Question by:ajaybelde
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 39903750
If B calls a procedure or function owned by A or other schema that has privileges to modify/lock A's objects then B can lock A through those.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39903756
Is it possible that B has a privileged role like say, DBA, that might allow access?
0
 

Author Comment

by:ajaybelde
ID: 39903795
Sdstuber,

how can i check if B is trying to access A by any Proc or function
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question