OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » authorization schemes not allowing any access to the page

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » authorization schemes not allowing any access to the page (4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

authorization schemes not allowing any access to the page [message #551142]

Sun, 15 April 2012 17:35

newprogrammerSQ
Messages: 48
Registered: April 2012

Member

I've tried to implement authorization scheme on Administration page with the following code:

select 1 from helpdesk_user where user_login = :APP_USER and user_accesslevel = 'Yes'

user_accesslevel is option field with output either Yes or No...

I've tried opening page with user as admin and a user as No... both do not load...

Access denied by Page security check
You need to be an admin user to view this page.

What am i doing wrong???

Report message to a moderator

Re: authorization schemes not allowing any access to the page [message #551143 is a reply to message #551142]

Sun, 15 April 2012 18:13

newprogrammerSQ
Messages: 48
Registered: April 2012

Member

Problem fixed! for anyone with same problem:

:APP_USER only recognises usernames in capital letters...

I have now set the username textbox to automatically change to uppercase by changing HTML Form Element Attributes to "onchange="this.value=this.value.toUpperCase();"

Report message to a moderator

Previous Topic:	Log in page on APEX
Next Topic:	help with WHERE CLAUSE on report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 28 18:49:10 CST 2026