Bug: Grants and proxy user

GolezTrol2

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

squigley

Good Morning!

Can you confirm what version of Oracle and Schema Compare for Oracle that you're seeing this under?

Thanks!

GolezTrol2

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

squigley

Can you try testing with 12c to see if there's any difference?

GolezTrol2

-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.

squigley

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.

GolezTrol2

Thanks. Done:
https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/38452696-grants-are-not-detected-correctly-when-logged-in-a

GolezTrol2

Thanks. Done:
https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/38452696-grants-are-not-detected-correctly-when-logged-in-a