topic Re: For connecting to Oracle database why do I need V$LOG permission in Qlik Replicate

For connecting to Oracle database why do I need V$LOG permission

Laura_NJ — Fri, 09 Feb 2024 22:51:28 GMT

I would like use Qlik replicated for 1 table view to do daily full load. CDC will be off. DBA wants to grant only the minimum permissions needed. No access to ASM will be given. Why do I need V$LOG permission?

What are the minimum required permissions if not doing CDC?

Re: For connecting to Oracle database why do I need V$LOG permission

john_wang — Sat, 10 Feb 2024 03:28:18 GMT

Hello @Laura_NJ ,

Thanks for reaching out to Qlik Community!

If I understood correctly, you are meaning a warning message in the Oracle source endpoint "Test Connection" operation:

SYS-E-HTTPFAIL, Select permission check failed for V$LOG.
SYS,GENERAL_EXCEPTION,Select permission check failed for V$LOG,ORA-00942: table or view does not exist

This is the default behavior of the endpoint permission verification for Oracle source CDC functionality. This warning message does not impact the Full Load ONLY task (for both tables and views replication) running.

Hope this helps.

John.

Re: For connecting to Oracle database why do I need V$LOG permission

Laura_NJ — Sat, 10 Feb 2024 05:53:41 GMT

Thank you!

Re: For connecting to Oracle database why do I need V$LOG permission

NTHUN — Mon, 19 Feb 2024 13:35:54 GMT

Hello @john_wang ,
I have the same problem in QCDI. I cannot create a connection to an oracle database because the user does not have the required permission (V&LOG etc.).
Can I still create a connection for a full load or are the permissions absolutely necessary? How do I set the connection to only do a full load?

Best regards

Re: For connecting to Oracle database why do I need V$LOG permission

john_wang — Mon, 19 Feb 2024 13:40:27 GMT

Hello @NTHUN ,

Full Load task need not the V$LOG permission, the task should run fine without it. How about if you simply ignore the warning and go ahead with the setup?

thanks,

John.

Re: For connecting to Oracle database why do I need V$LOG permission

NTHUN — Tue, 20 Feb 2024 12:11:52 GMT

Hello @john_wang,

how can I ignore the warning? It makes no difference whether I test or try to create the connection. I just get the message and can only choose "Close". Do you have any idea?

Thank you!

Re: For connecting to Oracle database why do I need V$LOG permission

john_wang — Tue, 20 Feb 2024 12:21:22 GMT

Hello @NTHUN ,

Seems you are hitting error on another object, SYS.OBJ$, it's different than V&LOG.

In Oracle SYS.OBJ$ is a basic system table, it contains all objects include tables, views etc. The permission is need for this system table. Please grant the access to it.

Hope this helps.

John.

Re: For connecting to Oracle database why do I need V$LOG permission

SushilKumar — Thu, 22 Feb 2024 11:19:09 GMT

Hello Team,

to add to the previous comments. SYS.OBJ$ is referred to get the object id assigned by the database. during the change processing/Execution plan and ongoing operation on the tables in the memory object_id comes into the picture as participating table referred by object id not by the Table_name.

Reagrds,

Sushil Kumar