Forum Stats

  • 3,825,769 Users
  • 2,260,558 Discussions
  • 7,896,671 Comments

Discussions

Grouping databases with CMU

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

Answers