cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1834
Views
0
Helpful
1
Replies

Oracle Adapter connection to 11g

Will Fleury
Level 1
Level 1

We are attempting to connect a Tidal Oracle Adapter to an 11g Db and it will not connect (Connect failed with exception (java.sql.SQLException: ORA-00942: table or view does not exist). In looking at all Oracle Adapter information, there is nothing listed for security for users past 10g.  Are there any tricks we are missing for this connection to work?  We do have successful connections to 9i and 10g databases with existing adapters on ver. 5.3.1.               

1 Reply 1

james mar
Level 1
Level 1

I believe there are additional DB permissions, here is what we have granted for our 11g DB user:

create user tidaladapter identified by xxxxxxx
default tablespace users;

grant create session to tidaladapter;
grant Create any job to tidaladapter;
grant Execute any program to tidaladapter;
grant Execute any class to tidaladapter;
grant Manage Scheduler to tidaladapter;
grant execute on dbms_scheduler to tidaladapter;
grant execute on dbms_session to tidaladapter;

GRANT SELECT on sys.v_$parameter to tidaladapter;
GRANT SELECT on sys.v_$instance to tidaladapter;
GRANT SELECT on dba_tables to tidaladapter;
GRANT SELECT on dba_users to tidaladapter;
GRANT SELECT on dba_stmt_audit_opts to tidaladapter;
GRANT SELECT on sys.obj$ to tidaladapter;
GRANT SELECT on sys.user$ to tidaladapter;
GRANT SELECT on sys.tab$ to tidaladapter;
GRANT SELECT on dba_scheduler_jobs to tidaladapter;
GRANT SELECT on user_scheduler_jobs to tidaladapter;
GRANT SELECT on dba_sys_privs to tidaladapter;
GRANT SELECT on v_$parameter to tidaladapter;
GRANT SELECT on v_$instance to tidaladapter;

GRANT SELECT on DBA_SCHEDULER_SCHEDULES  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_PROGRAMS  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_JOBS to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_GLOBAL_ATTRIBUTE  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_JOB_CLASSES  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_WINDOWS  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_JOB_RUN_DETAILS  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_WINDOW_GROUPS  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_WINGROUP_MEMBERS  to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_RUNNING_JOBS to tidaladapter;

/* BEGIN might not work depending on oracle version */
GRANT SELECT on DBA_SCHEDULER_JOB_ARGUMENTS to tidaladapter;
GRANT SELECT on DBA_SCHEDULER_PROGRAM_ARGUMENT to tidaladapter;
/* END */

GRANT SELECT on STMT_AUDIT_OPTION_MAP to tidaladapter;
GRANT SELECT on AUDIT_ACTIONS to tidaladapter;
GRANT SELECT on ALL_DEF_AUDIT_OPTS to tidaladapter;
GRANT SELECT on DBA_STMT_AUDIT_OPTS to tidaladapter;
GRANT SELECT on DBA_PRIV_AUDIT_OPTS to tidaladapter;
GRANT SELECT on DBA_OBJ_AUDIT_OPTS to tidaladapter;
GRANT SELECT on USER_OBJ_AUDIT_OPTS to tidaladapter;
GRANT SELECT on DBA_AUDIT_TRAIL to tidaladapter;
GRANT SELECT on USER_AUDIT_TRAIL to tidaladapter;
GRANT SELECT on DBA_AUDIT_OBJECT to tidaladapter;
GRANT SELECT on USER_AUDIT_OBJECT to tidaladapter;
GRANT SELECT on DBA_AUDIT_SESSION to tidaladapter;
GRANT SELECT on USER_AUDIT_SESSION to tidaladapter;
GRANT SELECT on DBA_AUDIT_STATEMENT to tidaladapter;
GRANT SELECT on USER_AUDIT_STATEMENT to tidaladapter;
GRANT SELECT on DBA_AUDIT_EXISTS to tidaladapter;
GRANT SELECT on DBA_AUDIT_POLICIES to tidaladapter;
GRANT SELECT on DBA_FGA_AUDIT_TRAIL to tidaladapter;