Progress
Database Administration
Guide and Reference


Establishing a Progress User ID and Password

Every Progress database connection has an associated user ID. Each type of Progress application security uses the user ID to determine the user’s authority to access data.

At the first level, connection security, you decide whether to allow all users the authority to connect to a database or to establish a list of authorized user IDs. Each user ID can be further protected by a password to prevent unauthorized users from connecting to the database.

If you choose not to establish a list of valid user IDs, then the database inherits user IDs or user names from the operating system.

On UNIX, the database uses the operating system user ID. Note that the user IDs or user names on these operating systems must adhere to Progress rules on user IDs. For more information, see the "Progress User ID" section.

If you choose to establish a list of valid user IDs with passwords, then you must enter the data into the user list. You can access the user list through the Data Dictionary Security menu. The database engine stores the user list in the _User table, which is hidden from users. From then on, the user must specify a user ID and password when connecting to the database. Note that the database no longer inherits the user ID or user name from the operating system once you have established this list.

In an interactive session, the application can prompt the user for a user ID and password. In a batch session, the user can specify a user ID and password by using the User ID (-U) and Password (-P) startup parameters.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095