Kbase 20655: Progress Security with Blank Passwords, Connecting w/ SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
Progress 9.1x
SYMPTOM(s):
Connection via SQL-92 as sysprogress fails using blank password
Connection via SQL-92 with valid userID and blank password fails
Error accessing database with SQLExplorer
Error accessing database via SQL-92 ODBC connection
Access denied(Authorization failed) (7512)
[JDBC Progress Driver]:Access denied(Authorisation failed)
CAUSE:
If Progress security has been enabled on a Progress 9.x database and users are set up with userIDs and blank passwords, the users cannot log in through the SQL-92 driver.
This scenario, though uncommon, is possible because Progress security allows the use of blank passwords. If security is enabled, however, the Progress SQL engine does not allow users to connect with a blank password, even if they are set up with blank passwords in the _user table.
Ideally, if security is a priority, passwords will be required for all users.
FIX:
Via the Data Dictionary, delete the user and recreate them with passwords.