This content has been marked as final. Show 3 replies
you can build table like
and use function like this
CREATE TABLE "USER_LOGIN" ( "USER_NAME" VARCHAR2(50) NOT NULL ENABLE, "USER_PASS" VARCHAR2(50))
now change your Authentication Schemes
create or replace FUNCTION "AACU_F" ( p_username IN VARCHAR2, p_password IN VARCHAR2) RETURN BOOLEAN IS BEGIN FOR c1 IN (SELECT 1 FROM USER_LOGIN WHERE UPPER(USER_NAME) = UPPER(p_username) AND UPPER(USER_PASS) = UPPER(p_password)) LOOP RETURN TRUE; END LOOP; RETURN FALSE; END;
Scheme Type : custom
in Authentication Function Name : use the function name you created (AACU_F) .
Which "built-in users" table are you referring to?
If you want to create your own table with your own usernames and passwords, Abo showed how to do that above (though you would really, really, really) want to store a password hash rather than storing the actual password and you would want that hash to include some randomly generated salt that would also be stored in the table.
But if you are talking about leveraging either Oracle's built-in table or APEX's built in table of users, APEX provides built-in authentication methods for APEX accounts and for Oracle accounts that you can simply choose. There is no need to write any code to take advantage of these options.