The definition of the connection to the database is defined in the assignment file. This will usually include the username and password. If you want to have different usernames and passwords for each of the users, then you will either need to use different assignment files for each user, or you could use the question mark in the assignment file in place of the username and password.

For example:

would prompt the user for a username and password when the user logs in.

To avoid multiple assignment files, which would involve a higher maintenance cost, you can use the #FILE directive to include one assignment file in another.

For example:

....

where j: is a personal drive, specific to which ever user is logged on. This is usually set up as an area on the server which only that user can access.

In the path.asn file, include all the logons that you require. In this way, for each user you create you need to set up the path.asn file in their personal directory on the j drive. Any other non user specific elements of the assignment file are held in the main assignment file, so changes to these need only be done in one place.

This structure ensures that the passwords are held in directories which are already secured by the local server setup, and will allow them only to be visible by the specified user.

Copyright ©2000 OCS Consulting plc