Home » Developer & Programmer » Application Express & MOD_PLSQL » authorization schemes not allowing any access to the page (4.0)
authorization schemes not allowing any access to the page [message #551142] Sun, 15 April 2012 17:35 Go to next message
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???
Re: authorization schemes not allowing any access to the page [message #551143 is a reply to message #551142] Sun, 15 April 2012 18:13 Go to previous message
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();"
Previous Topic: Log in page on APEX
Next Topic: help with WHERE CLAUSE on report
Goto Forum:
  


Current Time: Sat Aug 30 05:16:43 CDT 2014

Total time taken to generate the page: 0.14101 seconds