Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Redirect to original application url/page after authentication?

AllenS.Mar 23 2021 — edited Mar 23 2021

Hi,
I'm trying to create a somewhat centralized authentication for my applications and so I created an application for the purpose of handling the authentication.
So basically I have an application (authentication) which has the necessary authentication scheme setup.
Settings: Authentication Function Name -> mycustom_function
Session Not Valid: Go to URL -> f?p=authentication:LOGIN_DESKTOP
Login Processing: Switch in Session -> Enabled
Session Sharing: Type -> Workspace Sharing
I then created another application (app1) and subscribed to this authentication scheme. When running app1 going to page 1, I am redirected to the login page of the application authentication which is expected. However, after a successful login, it doesn't redirect me to the original page (page 1) from application app1. Instead, it redirects me the page 1 of application authentication.
Are there any setup that I might have missed?
Appreciate any help.
Regards,
Allen

Comments

sb92075
How do I ask a question on the forums?
2176552

http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_10002.htm#i2065706
Nicosa-Oracle
Hi,

I guess your user needs the flashback privilege granted : 
grant flashback on your_table to your_user;
unknown-7404
Note the last paragraph in the SQL Reference doc for the SELECT statement:
>
Prerequisites

For you to select data from a table or materialized view, the table or materialized view must be in your own schema or you must have the SELECT privilege on the table or materialized view.

For you to select rows from the base tables of a view:

•You must have the SELECT privilege on the view, and

•Whoever owns the schema containing the view must have the SELECT privilege on the base tables.

The SELECT ANY TABLE system privilege also allows you to select data from any table or any materialized view or the base table of any view.

To issue an Oracle Flashback Query using the flashback_query_clause, you must have the SELECT privilege on the objects in the select list. In addition, either you must have FLASHBACK object privilege on the objects in the select list, or you must have FLASHBACK ANY TABLE system privilege.
1 - 3

Post Details

Added on Mar 23 2021
#apex-discussions, #authentication
6 comments
2,027 views
1 mention