Create a DBA user to use in the Oracle InForm User Management Tool installation

1. Create a DBA user and grant the user these privileges:
   • CREATE USER, ALTER USER, DROP USER WITH ADMIN OPTION
   • ALTER SYSTEM
   • CONNECT, RESOURCE WITH ADMIN OPTION
   • UNLIMITED TABLESPACE WITH ADMIN OPTION
   • CREATE TABLESPACE
   • ALTER TABLESPACE
   • DROP TABLESPACE
   • CREATE TABLE WITH ADMIN OPTION
   • QUERY REWRITE WITH ADMIN OPTION
   • CREATE SYNONYM WITH ADMIN OPTION
   • ADMINISTER DATABASE TRIGGER WITH ADMIN OPTION
   • CREATE TRIGGER WITH ADMIN OPTION
   • CREATE TYPE WITH ADMIN OPTION
   • CREATE VIEW WITH ADMIN OPTION
   • ANALYZE ANY WITH ADMIN OPTION
   • ANALYZE ANY DICTIONARY WITH ADMIN OPTION
   • CREATE ANY DIRECTORY WITH ADMIN OPTION
   • DROP ANY DIRECTORY WITH ADMIN OPTION
   • EXP_FULL_DATABASE
   • IMP_FULL_DATABASE
   • EXECUTE ON DBMS_DATAPUMP WITH GRANT OPTION
   • AQ_ADMINISTRATOR_ROLE WITH ADMIN OPTION
   • AQ_USER_ROLE WITH ADMIN OPTION
   • EXECUTE ON DBMS_AQADM WITH GRANT OPTION
   • EXECUTE ON DBMS_AQ WITH GRANT OPTION
   • EXECUTE ON SYS.DBMS_LOCK WITH GRANT OPTION
   • SELECT ON V_$DATABASE WITH GRANT OPTION
   • SELECT ON ALL_USERS WITH GRANT OPTION
   • SELECT ON ALL_TAB_PRIVS WITH GRANT OPTION
   • SELECT ON ALL_TAB_COLUMNS WITH GRANT OPTION
   • SELECT ON ALL_SOURCE WITH GRANT OPTION
   • SELECT ON ALL_DB_LINKS WITH GRANT OPTION
   • SELECT ON DBA_TABLESPACES WITH GRANT OPTION
   • SELECT ON DBA_TABLES WITH GRANT OPTION
   • SELECT ON DBA_INDEXES WITH GRANT OPTION
   • EXECUTE ON SYS.UTL_RECOMP WITH GRANT OPTION
   • EXECUTE ON UTL_HTTP WITH GRANT OPTION
   • EXECUTE ON UTL_TCP WITH GRANT OPTION
   • EXECUTE ON UTL_SMTP WITH GRANT OPTION
   • EXECUTE ON UTL_URL WITH GRANT OPTION
   • EXECUTE ON DBMS_RANDOM WITH GRANT OPTION
   • EXECUTE ON DBMS_OBFUSCATION_TOOLKIT WITH GRANT OPTION
   • EXECUTE ON SYS.DBMS_SQL WITH GRANT OPTION
   • EXECUTE ON SYS.DBMS_LOB WITH GRANT OPTION
   • EXECUTE ON SYS.UTL_FILE WITH GRANT OPTION
   • EXECUTE ON SYS.DBMS_JOB WITH GRANT OPTION
   • CREATE PROFILE
   • CREATE MATERIALIZED VIEW WITH ADMIN OPTION
   • CREATE PROCEDURE WITH ADMIN OPTION
   • EXECUTE ON SYS.ORA12C_STRONG_VERIFY_FUNCTION
   • EXECUTE ON SYS.DBMS_RANDOM
2. Validate the database connection:

   sqlplus <created DBA user>@<tnsnames_alias>

   At the prompt, enter the content user password.

   If the test is successful, a SQL prompt appears, showing that you have logged on to the database server. An unsuccessful test generates an ORA- error. Consult your database administrator for help in troubleshooting errors.