on 04-18-2008 6:47 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.