Bug: Grants and proxy user
GolezTrol2
Posts: 8 New member
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
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Schema Compare 5.4.0.2010
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
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.
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/38452696-grants-are-not-detected-correctly-when-logged-in-a
https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/38452696-grants-are-not-detected-correctly-when-logged-in-a