Skip to content

Setup DB Pool Connection User

Spencer Mahaffey edited this page Jan 5, 2015 · 1 revision
  1. Create INIA_POOL user
  2. Assign Permissions
  3. Change Default Tablespace to INIA
  4. Need to also create a logon trigger or all of the SQL code breaks as nothing is prefixed with 'INIA.table'

create or replace TRIGGER db_logon AFTER logon ON DATABASE WHEN (USER = 'INIA_POOL') BEGIN execute immediate 'ALTER SESSION SET CURRENT_SCHEMA = INIA'; END;

Clone this wiki locally