Open users in MDD

[Former Member]

Hi

I Hav found some active users in my MDD database when i executed following command.

SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS

-

---

-

---

SRMMDMCATALOG1_Z001 OPEN

SRMMDMCATALOG1_M001 OPEN

SRMMDMCATALOG1_Z000 OPEN

SRMMDMCATALOG1_M000 OPEN

SRMMDMCATALOG_Z000 OPEN

SRMMDMCATALOG_M000 OPEN

A2I_XCAT_DBS OPEN

MGMT_VIEW OPEN

MDM OPEN

I am not sure what are these users? ( I am aware of Admin, Master, USer1 etc.). And what is the role of these users in working of repository.

Regards

[Former Member]

Hi Sapbasis,

I am not sure that who these users are but however i would like to share with you some knowledege related to your case.

SRMMDMCATALOG1_Z001 OPEN

SRMMDMCATALOG1_M001 OPEN

SRMMDMCATALOG1_Z000 OPEN

SRMMDMCATALOG1_M000 OPEN

SRMMDMCATALOG_Z000 OPEN

SRMMDMCATALOG_M000 OPEN

A2I_XCAT_DBS OPEN

MGMT_VIEW OPEN

MDM OPEN

Out of the list that you have provided.

SRMMDMCATALOG1_Z001 OPEN appears to be a database table name and not users

<tablename>_ Z001

<table name>_M001

Whenever you create a Rep two tables are created in the data base in this format

the M001 table -> points to the current table

the Z001->points to the data changes if change tracking is enabled

So seems like the info you have provided shows rep table in data base which are in use.

Lets see what others have to say

Hope it helps

Kindly reward points if found useful

Thanks

SImona