
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Errors when starting task for the first time - logstream to Oracle database. Insufficient privileges
GRANT SELECT ON SYS.ALL_CONSTRAINTS TO USER;
GRANT SELECT ON SYS.ALL_CONS_COLUMNS TO USER;
GRANT SELECT ON SYS.ALL_INDEXES TO USER;
GRANT SELECT ON SYS.ALL_IND_COLUMNS TO USER;
GRANT ALTER ANY TABLE TO USER;
GRANT CREATE ANY INDEX TO USER;
GRANT CREATE ANY TABLE TO USER;
GRANT DELETE ANY TABLE TO USER;
GRANT DROP ANY TABLE TO USER;
GRANT INSERT ANY TABLE TO USER;
GRANT SELECT ANY TABLE TO USER;
GRANT UPDATE ANY TABLE TO USER;
Any ideas on what I might be missing?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Can you try with unchecking "Use direct path full load" on the advanced tab of the oracle endpoint
Also i've seen a similar issue and the fix was to grant LOCK ANY TABLE to ATTREP;
It seems the permissions which are missing from the TARGET (not SOURCE):
Thanks
Lyka

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Can you try with unchecking "Use direct path full load" on the advanced tab of the oracle endpoint
Also i've seen a similar issue and the fix was to grant LOCK ANY TABLE to ATTREP;
It seems the permissions which are missing from the TARGET (not SOURCE):
Thanks
Lyka

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That worked! It performed the Full Load. But, instead of writing to the table that I had already created, it created another table. Is there a reason that it did not use the existing table?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My error! I found that I had entered the table name in mixed case in the Table Name field. It is now loading the correct table.
Thanks for much for the help!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Im glad that worked out for you 🙂
Thanks
Lyka
