APEX

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!

Display All record if User is ADMIN

VedantMay 9 2011 — edited May 10 2011

hi,

i have created SQL report .if user is not admin then display record with respective user_id.

My report code is

select * from CRM_ISSUE_PROBLEM where user_id=:APP_USER

But if user is Admin then i want to display all record to admin.what condition should i pass in condition.

How can i do this.

i am using Access COntrol Page to Authorization.

Vedant

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2011

Added on May 9 2011

#apex-discussions

6 comments

759 views