DB version: 11.2
Platform : RHEL 6.5
I have the following application schemas in my DB. Each of these business schemas have hundreds of objects in it.
HRTB_MS
HWPY_MS
GEPR_PERS_MS
I have individual application admin users named APP_ADMIN_JOHN . I want APP_ADMIN_JOHN user to have SELECT, INSERT , DELETE, UPDATE privileges
on all objects of the above schemas. This way I can track who is actually making any changes other than the application schema user itself.
Can this be done without script ? ie. GRANTs executed via Cursor Loop.
Reason why I need this:
Currently , app support admin users login using application schema directly and make ad-hoc changes/back-end changes which cannot be changed by the application. But if something goes wrong while doing this back-end changes, I cannot track who actually made that bad change.