Da********@gmail.com wrote:
Thanks for your reply.
My main question is: Are other SAP installations really like
this????
<quote>
Here is what I got from the SAP residends:
"This is the design SAP is based on. Each system ( if they need to be
part of the transport system) needs a unique SID (3 letters). The SID is
part of the user name
Admin user = <sid>adm
dbuser = db2<sid>, ora<sid>, inf<sid>
schema owner = sap<sid>
This design takes also in account that usually more users are allowed to
maintain a sandbox system then the production box. Especially in large
companies only a few dba's are allowed to work on production. This is
also part of our security design. SAP allows to have multiple systems on
one box and by using the same users to maintain different systems the
risk of working with the wrong system is too big. Besides I don't think
Sarbanes-Oxley would allow such a design.
Since the sid is part of the user there is not much to remember anyway.
You need to know which system you would like to work on like
PRD
QAS
TST
then you know the user to use as well, because they all have the same
pattern. If the customer likes he can use the same password for all
systems. That's his decision.
Btw. we never hat this complain before.
To answer the last question below, yes all SAP installations work like this.
</quote>
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab