Set up Oracle source endpoint (Full load only)

[eksmirnova]

Hi everyone,

I need to set up an Oracle source endpoint only for Full loads( no CDC is needed).

Does the user which specified in the connection settings still has to have all the permissions?

• SELECT ANY TRANSACTION
• SELECT on V_$ARCHIVED_LOG
• SELECT on V_$LOG
• SELECT on V_$LOGFILE
• SELECT on V_$DATABASE
• SELECT on V_$THREAD
• SELECT on V_$PARAMETER
• SELECT on V_$NLS_PARAMETERS
• SELECT on V_$TIMEZONE_NAMES
• SELECT on GV_$TRANSACTION
• SELECT on V_$CONTAINERS
• SELECT on ALL_INDEXES
• SELECT on ALL_OBJECTS
• SELECT on DBA_OBJECTS
• SELECT on ALL_TABLES
• SELECT on ALL_USERS
• SELECT on ALL_CATALOG
• SELECT on ALL_CONSTRAINTS
• SELECT on ALL_CONS_COLUMNS
• SELECT on ALL_TAB_COLS
• SELECT on ALL_IND_COLUMNS
• SELECT on ALL_LOG_GROUPS
• SELECT on SYS.DBA_REGISTRY
• SELECT on SYS.OBJ$
• SELECT on SYS.ENC$
• SELECT on DBA_TABLESPACES
• SELECT on ALL_TAB_PARTITIONS
• SELECT on ALL_ENCRYPTED_COLUMNS
• If views are exposed: SELECT on ALL_VIEWS
• CREATE SESSION
• EXECUTE on DBMS_LOGMNR
• SELECT on V_$LOGMNR_LOGS
• SELECT on V_$LOGMNR_CONTENTS

• LOGMINING

Or any of those permissions might be skipped?

As far as I understand Qlik does not use REDO/Archived logs for Full load. But I am still getting that error when I set up the endpoint: Select permission check failed for V$LOGMNR_LOGS

Thank you in advance for the answer!

[narendersarva]

Hi @eksmirnova 

Yes, you are correct Qlik does not use REDO/Archived logs for Full load as this a direct table extract instead of reading from redo logs.  Please check Grant SELECT permissions accordingly on the relevant objects in full load. You might need to raise a support case to share the logs to technical support engineer to go over.

Thanks
Naren

[eksmirnova]

So I do not need "SELECT on V_$LOGMNR_LOGS" permissions to set up endpoint, right? 

But I am getting this error: 

[Dana_Baldwin]

Hi @eksmirnova 

Just to confirm, the task is set to only perform a full load? Apply/Store changes is disabled in task settings?

Thanks,

Dana

[Heinvandenheuvel]

WHEN are you getting the Select permission check failed error?

Is this perhaps using the TEST CONNECTION button on the Endpoint, or while trying to run a task.

Using TEST, then end point does not know which task will be using it and not how it might be used. The test button is on the 'first' page so one could argue (poor argument I admit) it does not even know yet how you are about to configure the advanced parameters and it tests for everything.

If the error is reported during 'test connection' then I suggest you just ignore it. The connection was tested in order to get this message so you are all set. :-). 

I would also argue (another poor argument I admit) to just give it a couple more permission. You are essentially already given full access to pretty much everything and need to be able to 100% trust the username offered to Replicate - what's another few permissions between friends?! Yeah, your DBA will possibly fight over every single one, but just tell them (yourself?) that you are terribly sorry but this seems to be needed.

Cheers,

Hein.

[eksmirnova]

Yes, that is correct. Apply/Store changes are disabled

[Heinvandenheuvel]

>>> Yes, that is correct. Apply/Store changes are disabled

Please confirm WHEN you are seeing the message. What actions lead to the message?

If you can attach (relevant parts) of the reptask_xxx.log or repctl.log containing the message(s) to a reply. Consider renaming/copying to .TXT before attaching for ease of acces to the folks trying to help.

Hein