You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Spencer Mahaffey edited this page Jan 5, 2015
·
1 revision
Create INIA_POOL user
Assign Permissions
Change Default Tablespace to INIA
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;