Creating the Database Login Scheme and Service

Use this procedure to create a database service that uses a login scheme with either the USE_USER_ID or the USE_PRIVILEGED_ID login procedure. You do not need to perform this procedure if all database access authentication is based on the user and password in the $LARUNDIR/dataarea/db.cfg file. To complete this procedure, you will use the values for the following secadm parameters:

Parameter Description
db_servicename The name of the database service.
login-scheme-name The name of the database login scheme that specifies a login procedure of USE_USER_ID or USE_PRIVILEGED_ID.
Note: 

Only parameters required for database user authentication are shown in this procedure. You can use the default settings for other parameters on the commands.

To create a database login scheme and database service

  1. Create the login scheme for the database user. At a Landmark command prompt, type

    secadm loginscheme add login-scheme-name --schemetype DBLogin --allowedservicetypes Database --loginprocedure USE_USER_ID

    or

    secadm loginscheme add login-scheme-name --schemetype DBLogin --allowedservicetypes Database --loginprocedure USE_PRIVILEGED_ID

  2. Create a service for the login scheme you defined. At a Landmark command prompt, type

    secadm service add db_servicename --servicetype Database --version 2.0 --loginscheme login-scheme-name