In SQL, you must be connected to a database before issuing commands. When you use a SQL connection in DB Navigator to connect to a database, you must supply a user ID and, optionally, a password. If the user ID and password are not in the connection profile, you are prompted to provide them.

Frequently, databases do not have user accounts defined. For example, you might decide not to set up users for a local, working copy of a database that you are using for testing or development. Or, you may implement security on the application level so that database user accounts are not necessary.

If you are connecting to a database with no defined users, keep the following in mind:

  • You can log in with any string of characters as a user ID and, optionally, a password. However, you need a login account with database administrator (DBA) privileges if you want to create, modify, or delete database objects, or if you want to view application data.
  • DBA privileges are associated with the Windows login of the creator of the database. If you created the database, enter your Windows user name. No password is required.
If you are connecting to a database with defined users, contact the database administrator to set up a user account that has DBA privileges. If you are unsure which users have DBA privileges, you can check the _SYSDBAUTH system table for a list of user privileges.
Note: If you create a user account for an OpenEdge database that has no user accounts defined, make sure that the first account you create has DBA privileges. If the first account does not have DBA privileges, you cannot add a DBA account or any additional user accounts.

See OpenEdge Data Management: SQL Development and OpenEdge Data Management: SQL Reference for more information. You can find these OpenEdge manuals in the Product Documentation section of the Progress Software Developer's Network Web site.