Custom Authentication in Oracle APEX
http://blog.csdn.net/sunansheng/article/details/50409012
-
This document is based on:
-
-
Oracle APEX 5.0
-
-
Create USER_ACCOUNT table:
-
123456789101112131415161718192021222324252627282930
create
table
USER_ACCOUNT
(
USER_NAME VARCHAR2(30)
not
null
,
PASSWORD
VARCHAR2(30)
not
null
,
USER_TYPE VARCHAR2(10)
not
null
,
ACTIVE VARCHAR2(1)
not
null
,
EMAIL VARCHAR2(64)
not
null
,
FULL_NAME VARCHAR2(64)
not
null
) ;
alter
table
USER_ACCOUNT
add
constraint
USER_ACCOUNT_PK
primary
key
(USER_NAME) ;
alter
table
USER_ACCOUNT
add
constraint
USER_ACCOUNT_UK
unique
(EMAIL) ;
-----------------------------------
insert
into
user_account (USER_NAME,
PASSWORD
, USER_TYPE,
ACTIVE, EMAIL, FULL_NAME)
values
(
'tom'
,
'tom123'
,
'admin'
,
'Y'