User | Default Name | Default Group | DBMS Access | LeasePak Server Access | LeasePak Client Access |
---|---|---|---|---|---|
DBMS server administrator ($SRVADM) | sysdba or sa 1 |
n/a | direct1 | ||
LeasePak database administrator ($NSTDBA) | nstdba | $NSTGROUP2 | 3 | direct | |
LeasePak release administrator ($NSTADMIN) | nstadmin | $NSTGROUP2 | direct |
1$SRVADM accesses the DBMS using the role of either Oracle sysdba
or Sybase sa
.
2$NSTGROUP is the required primary group for $NSTADMIN and $NSTDBA.
3$NSTDBA does not access the DBMS directly, but does require the use of $SRVADM and LeasePak database owner (DBO) passwords to run most of the LeasePak server scripts that it administers.
$SRVADM is not allowed to be a UNIX user at the time of the LeasePak server installation and has no membership in any Unix groups. Instead, $SRVADM is a DBMS user that is granted the role and performs the functions of either Oracle sysdba
or Sybase sa
to administrate the database server, individual schemas or databases, and users during execution of LeasePak server programs and scripts.
LeasePak server user, referred to by parameter and environment variable $NSTDBA. Owns and runs all LeasePak database utility scripts ($ubin/db_*).
The LeasePak server system administrator must set up the LeasePak database administrator user account as part of LeasePak server preparation prior to installing the LeasePak server software.
Suggested user name | Required primary group |
---|---|
nsdba76a | $NSTGROUP |
During LeasePak server software installation, the LeasePak SETUP program prompts for the $NSTDBA user name. The program checks /etc/passwd
to verify that the supplied user exists. SETUP also assigns the account to the administrative environment (adm_ora or adm_syb).
Do not set up $NSTDBA as a DBMS user or LeasePak client user.
Do not change $NSTDBA's environment.
Because $NSTDBA must remain as configured by SETUP, NetSol strongly recommends that system administrators set up a separate $NSTDBA user for each LeasePak release on the server and follow a naming convention that embeds the LeasePak release version in the user name.
$NSTDBA owns and runs all LeasePak database utility scripts ($ubin/db_*). Users with access to $NSTDBA's credentials will also need additional passwords to run these scripts, including DBMS root user, Database server administrator ($SRVADM), and LeasePak database owner (DBO) passwords.
Performs tasks and runs scripts related to the configuration and administration of the LeasePak server software, including LeasePak queue manager configuration and setup_new_env.