Database Software

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 determine if a resource is available to a certain user?

Tomas AlbinssonNov 1 2010 — edited Nov 18 2010

This is in version 11.2.0.1.0.

We are developing a sort of report against resources and users. The report should only list resources that a given user has access to, according to the ACL.
So the report needs to find out "is user X allowed to see resource Y?".
What is the fastest and/or best way to find the answer?

The report is generated by a PL/SQL program so it doesn't have to be a SQL-solution. An api would be just as good.

Kind regards

Tomas Albinsson
Stockholm, Sweden

This post has been answered by mdrake-Oracle on Nov 17 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2010

Added on Nov 1 2010

#11g, #access, #performance-availability, #user, #xml-db

10 comments

356 views