Overriding Default Passwords in Specific Files

Passwords for ADABAS files can be set from the command line in FOCUS using the SET PASSWORD command. You can set default passwords for all files and/or databases. Specific passwords can be set for specific files which will override the default. The SET command overrides the password coded in the Access File.

The SET PASSWORD command remains valid throughout the user's session.

The syntax is

{CMS|MVS}  ADBSINX SET PASSWORD password FILENO ALL DBNO {ALL|dbno}
{CMS|MVS}  ADBSINX SET PASSWORD password FILENO fileno DBNO dbno
{CMS|MVS}  ADBSINX SET PASSWORD OFF
{CMS|MVS}  ADBSINX SET PASSWORD DEFAULT 

where:

CMS

Indicates the CMS operating system.

MVS

Indicates the MVS operating system.

password

Is the password, which can be from one to eight characters in length.

FILENO

Specifies the file number for which the password is set.

DBNO

Specifies the database or databases for which the password is set.

ALL

Indicates all files and/or databases used with the FILENO and DBNO parameters. If you want to use ALL for both FILENO and DBNO, issue this command before any other subsequent password commands. ALL overrides any prior settings.

dbno

Is any valid numeric database value between 0 and 255. The DBNO parameter indicates the actual database number.

OFF

Clears all previous ADBSINX SET PASSWORD commands. The ADABAS Interface does not use any passwords specified in the Access File. This command lets you access only those files that have no password security.

DEFAULT

Clears all previous ADBSINX SET PASSWORD commands and causes the ADABAS Interface to use the password in the Access File.

To set a default password:

• Issue the SET PASSWORD command using the ALL keyword for FILENO and/or DBNO.
• Issue specific password requests by specifying particular file and/or database numbers (or ranges) in a subsequent SET PASSWORD command.

Note that subsequent requests are appended to previous requests. Changes are cumulative. The passwords can be issued from a FOCEXEC, which may be encrypted. Refer to the FOCUS for IBM Mainframe User's Manual for more information on encryption.

Examples

To set a default password to MARY for all databases and all files under CMS, issue the following command:

CMS ADBSINX SET PASSWORD MARY FILENO ALL DBNO ALL

To set the password to DAN for all files in database number 150 under CMS, issue the following command:

CMS ADBSINX SET PASSWORD DAN FILENO ALL DBNO 150

To set the password to BRUCE for specific files in database number 123 under MVS, issue the following command:

MVS ADBSINX SET PASSWORD BRUCE FILENO 1,3-5,23,89-93 DBNO 123

To clear all previous ADBSINX SET PASSWORD commands under CMS, only allowing the user to access the files that have no password security, issue the following command:

CMS ADBSINX SET PASSWORD OFF

To clear all previous ADBSINX SET PASSWORD commands under MVS, causing the ADABAS Interface to use the password in the Access File, issue the following command:

MVS ADBSINX SET PASSWORD DEFAULT