All,
i guess this has been done many times so there should be excellent approach out there:
I've a database schema=CAI_DB which is the owner schema of objects in production - i need to setup access such that only DBA group can do everything.
But i need to give another set of users//developers read-only access and they dont want to create a common schema for development team since a developer can move to another department within the company so should not access anything at which point he should be locked/disabled.
But again i find creating multiple users with their credentials a lot of unnecessary work SO HOW CAN WE HAVE common user/schema account to read-only but when a developer move to another dept./retire he can be individually disable or removed.
also we are planning to have two schema in production: CAI_DBA (for DBA) and CAI_IT for developers and they can do development work here (from this schema in production server)
using:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
thanks