Thanks for the question, Mohammad.
Asked: March 05, 2017 - 1:06 pm UTC
Last updated: March 07, 2017 - 2:33 am UTC
Version: 12c
Viewed 1000+ times
You Asked
we have Exadata and we've started to implement snapshots.
the business case required:
we create a snapshots from the same test master, and grant access on each two snapshot for a specific group of users while preventing them to access other snapshots available.
is it possible to do that without need to modify the permissions on each snapshot (keep it centralized in the test master)?
we have:
- Exadata X5-2 quarter rack (Linux OS).
- data guard already configured and we have a standby DB.
- the test master also will be synced by data guard.
- no replication.
- regular DB, no CDB or PDB.
snapshots: snap1, snap2, snap3
users: user1,user2,user3,user4,user5,user6
so:
user1 and user2 have access to snap1 only.
user3 and user4 have access to snap2 only.
user5 and user 6 have access to snap3 only.
best regards
and Connor said...
A snapshot is a replica of a source database, so if the source gives access to user1,user2, etc... then *initially* the same access will be available in the snapshot.
However, once the snapshot is created (presumably read-write), there is nothing to stop you from applying whatever alterations to grants, passwords etc etc to the clone database to then prohibit access in whatever way you like.
You would script the alterations up so that when the snapshot is refreshed, you can re-apply the alterations to customise the access to whatever your needs are.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment