My company has about 40 databases with each database in a different logical partition. Presently the SysAdmin person says it is necessary to create a user profile (login and password for each instance of databases on each LPAR.
1. Is it necessary that the user must be created in each LPAR?
2. If this is the case, is there a way to automate the process, so that creation of a single user will create these accounts in each partition?
3. Is it possible that this is a requirement of each database and not a requirement of AIX (5.3)?
Thanks for helping. If possible please send answers to """rule10"""



---edit---
by pressy ((rule 10))
Don't post your email address and ask for an email reply. The forums are for the benefit of all, so all Q&A should take place in the forums.
----------

if the LPARs are on different servers with their own authentication mechanisms, yes it is required unless they can all authenticate through a centralized mechanism (i.e., NIS+ or LDAP) ...

if the LPARs are on 1 server, the user account requirement may be for each database ... but that would depend on how the databases are setup ... some might not require it ...

as for automation, there are a few out there that you can use --- we just use NIS+ where I work so I can't say too much for the 3rd party software ...