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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2008

Added on Oct 8 2008

#general-database-discussions

3 comments

42,965 views