Sep 5, 2018
Overriding the USER_TABLES and USER_VIEWS Public Synonyms
Overriding the USER_TABLES and USER_VIEWS Public Synonyms - #oracle #db
To increase the level of security on one of the applications I support, I had to create a new user (we’ll call this one APPUSERREAD) in our Oracle Database that had read-only access to the previous application user schema (and this one will be APPUSER).
One of the challenges at this point was to avoid changing the queries that were hard-coded into the application. Unfortunately, these queries…
View On WordPress