Bug: Grants and proxy user

When using a proxy user to log in, schema compare can't seem to find the existing grants. If I log in using the actual schema user, it works fine.If I'm logged in using the proxy user in an IDE like PLSQL Developer, I can see (and modify) grants just fine. Other schema objects can be found and read just fine as well, so there seems to be a specific bug regarding grants and proxy users in Schema Compare

Answers

  • squigleysquigley Posts: 78 Silver 1
    Good Morning!
    Can you confirm what version of Oracle and Schema Compare for Oracle that you're seeing this under?
    Thanks!

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





  • GolezTrol2GolezTrol2 Posts: 5 New member
    Oracle 11.2g using the 18c client. I should be able to test this using 12c as well, I think, if you need me to.
    Schema Compare 5.4.0.2010
  • squigleysquigley Posts: 78 Silver 1
    Can you try testing with 12c to see if there's any difference?

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





  • GolezTrol2GolezTrol2 Posts: 5 New member
    edited August 16, 2019 8:58AM
    -edit-
    I got some help from a DBA, allowing me to temporarily test this (normally I don't have proxy accounts available on my 12c development database).

    The behavior is the same on 12c. It also can't find the grants which it does find when logged in as a normal/schema user.

    It looks like a bug where at some point RGSC uses the typed in (proxy) username, rather than the user/schema it connects to, to query the grants from the database.
  • squigleysquigley Posts: 78 Silver 1
    Thanks for the update.
    I was able to look into this further on my end and discuss with the developers and they have confirmed that this is because the Schema Compare for Oracle tool wasn't designed to use proxy users, they require a normal user / schema log-in in order to work.

    If you would like for this to became a feature, I would highly recommend creating a uservoice request so the developers can see the demand for such a feature: https://redgate.uservoice.com/forums/174014-oracle-tools

    I apologize for the inconvenience that this might bring.



    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





Sign In or Register to comment.