Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check grants

597677Oct 8 2008 — edited Oct 8 2008
Hi,
I am getting an error for some users when they try to access an application.
ORA-04067

Now i am sure the packages are present and also other obejects are present, so only thing to check is that they have grants to execute them or not.

So please let me know how can i check that a particular user has right to access a SCHEMA and also an OBJECT in that SCHEMA.

Please help for both things.

Thanks and Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2008
Added on Oct 8 2008
3 comments
42,963 views