4 Database Manipulation
The DBLOGON Statement
DBLOGON establishes a logon to a database server, not to a certain database. During the DBOPEN and the following database statements, the username and the password is used to examine the permissions on that dataset.
DBLOGON (User$, Pswd$)
The parameters are:
- User$
- A string variable containing the username (not case sensitive). This is used to identify the user and associated privileges for subsequent database operations.
- Pswd$
- A string variable containing the password for the specified user (case sensitive).
The DBLOGON statement does not perform authentification by itself. It saves the user name and password which is used subsequently when connecting to a database server or opening a database. DBLOGON is typically specified only once and the authorization information is used for all databases. When no DBLOGON statement is executed or an empty user name is passed, the default user "public" is used.
The Eloquence data base provides a its own authorization scheme. A list of users is maintained per data base server. For each data base, there are authorization groups which have specific rights on this particular data base. A user can be a member of up to eight authorization groups.
For Eloquence A.05.xx databases (through the eloqdb5 server) the logon information is ignored and the database password is used.
Eloquence Database Manual - 19 DEC 2002