/****************************************************************************/
/* FILENAME:      INSTALL_DIRECT_1.sql                                      */
/* VERSION:       1.6                                                       */
/* DATABASE:      Oracle 8i,9i                                              */
/* SUMMARY:       Creates driver's database user account.                   */
/* INSTRUCTIONS:  Execute as user SYSTEM/MANAGER or some user with          */
/*                administrative privileges.                                */
/* DISPLAY:       monospaced                                                */
/****************************************************************************/


SET TERMOUT ON;
SET ECHO OFF;


/****************************************************************************/
/* Create 'dirxml' user account and grant privileges.                       */
/****************************************************************************/

CREATE USER idm IDENTIFIED BY dirxml
default tablespace USERS
quota unlimited on USERS
temporary tablespace TEMP;
GRANT CONNECT TO idm;
GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE, CREATE VIEW TO idm;
grant create user, alter user, drop user, create role, alter any role, drop any role, grant any role, grant any privilege to idm;
COMMIT;

/* Run as SYS with SQL+, SYSDBA required*/

GRANT SELECT ON sys.dba_users TO idm;
GRANT SELECT ON sys.dba_roles TO idm;
GRANT SELECT ON sys.dba_role_privs TO idm;

/* Run as idm after idm schema and objects created*/

/* GRANT INSERT ON idm.eventlog TO SYS; */