Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User access, roles and schema setup, DBA

Gor_MahiaJan 30 2025 — edited Feb 6 2025

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

This post has been answered by Gor_Mahia on Mar 12 2025
Jump to Answer
Comments
Post Details
Added on Jan 30 2025
1 comment
159 views