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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments
Post Details
Added on Jan 30 2025
0 comments
59 views