Hello Gurus,
Not sure if this is the right forum to ask the q, but I could not find any specific forum for CMU.
Given that CMU talks directly to AD, how can limit users to a group of databases?
Say 3 Data Archs wants access to a varying subset of databases. Without having to create multiple roles on the databases, how can one limit access for the Archs to only the targets they need access to -
DataArch_1 --> Ent_DataArch_Role --> {DB_1, DB_10, DB_11,...}
DataArch_2 --> Ent_DataArch_Role --> {DB_4, DB_6, DB_11,...}
...
Or do I have to create "Ent_DataArch_1_Role", "Ent_DataArch_2_Role"... in each of the databases they need access to?
Thanks,
aBBy