Load Ingest Data
Results 1 to 4 of 4

Thread: Oracle Permissions Required?

  1. #1
    frandsb is offline Junior Member
    Join Date
    Jul 2012
    Posts
    8
    Rep Power
    0

    Oracle Permissions Required?

    Hello-

    I have successfully tested CDC for Oracle by Attunity as delivered by Sql Server 2012 in a sandbox environment, where the user connecting was granted all access.

    Now I am attempting to move forward with using this tool, and my DBA will not grant permissions unless documented as necessary by Attunity. I have searched, but cannot find where this is detailed in any documentation. Can you point me to this?

    I have found this thread http://www.attunity.com/forums/chang...eeded-557.html which is very similar, but it is dated: seems to focus on Oracle 9. I need Oracle 10 information, and ideally in a format more formal than just a forum reply. :)

    Thanks!
    Brent

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Brent,

    The privileges required to be granted for the Oracle user are described in the Change Data Capture Designer for Oracle by Attunity help document, Connect to an Oracle Source Database section.

    The help document can be accessed by pressing F1 from Change Data Capture Designer UI.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    frandsb is offline Junior Member
    Join Date
    Jul 2012
    Posts
    8
    Rep Power
    0

    In addition, we also needed to grant SELECT on V$INSTANCE

    Thanks Gadi-

    The help file listed the below, but did not have this (which we needed): SELECT on V$INSTANCE
    A user must have the following privileges granted in the Oracle database to
    be a log-mining user.


    • SELECT on <any-captured-table>
      SELECT ANY TRANSACTION
      EXECUTE on DBMS LOGMNR
      SELECT on V$LOGMNR CONTENTS
    • SELECT on V$ARCHIVED LOG
    • SELECT on V$LOG
    • SELECT on V$LOGFILE
    • SELECT on V$DATABASE
    • SELECT on V$THREAD
    • SELECT on ALL INDEXES
    • SELECT on ALL OBJECTS
    • SELECT on DBA OBJECTS
    • SELECT on ALL TABLES

    If any of these privileges cannot be granted to a V$xxx, then grant them to
    the V_S$xxx.

    I'm still having a separate issue, but it was not resolved when elevating the user back to database owner, so I will pursue separately as not a permissions issue.

    Thanks!
    Brent

  4. #4
    mikedba is offline Junior Member
    Join Date
    Nov 2014
    Posts
    8
    Rep Power
    0
    Quote Originally Posted by frandsb View Post
    Thanks Gadi-

    The help file listed the below, but did not have this (which we needed): SELECT on V$INSTANCE
    A user must have the following privileges granted in the Oracle database to
    be a log-mining user.


    • SELECT on <any-captured-table>
      SELECT ANY TRANSACTION
      EXECUTE on DBMS LOGMNR
      SELECT on V$LOGMNR CONTENTS
    • SELECT on V$ARCHIVED LOG
    • SELECT on V$LOG
    • SELECT on V$LOGFILE
    • SELECT on V$DATABASE
    • SELECT on V$THREAD
    • SELECT on ALL INDEXES
    • SELECT on ALL OBJECTS
    • SELECT on DBA OBJECTS
    • SELECT on ALL TABLES

    If any of these privileges cannot be granted to a V$xxx, then grant them to
    the V_S$xxx.

    I'm still having a separate issue, but it was not resolved when elevating the user back to database owner, so I will pursue separately as not a permissions issue.

    Thanks!
    Brent
    This worked on Oracle 11r2 but isn't working on Oracle 12c. Has anyone found a solution short of granting DBA?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •