Test Users

Added by Susan Bramhall, last edited by Susan Bramhall on Apr 28, 2009  (view change)

PL/SQL test user create script

The pl/sql script in src/main/config/add_test_users.sql reads a file of netids, one per line, and adds each to the UP_PERSON_DIR table with a name of 'Yalie Tester' and an encrypted password. Before it reads the file it deletes all current rows with the name 'Yalie Tester'.

 To run the proc the DBA must first execute the following:

CREATE OR REPLACE DIRECTORY mydir AS '[real-file-path]';
GRANT read ON DIRECTORY mydir TO PORTAL_OWNER;

GRANT EXECUTE ON UTL_FILE TO PORTAL_OWNER;

To use the test users login to the test portal using url

https://[portal host]/Login?userName=[netid]&password=[password]

Labels

 
(None)