Kbase 21128: [MERANT][ODBC PROGRESS driver][PROGRESS]Access denied
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/06/2001 |
|
SUMMARY:
Error:
[MERANT][ODBC PROGRESS driver][PROGRESS]Access denied
(Authorisation failed)
after trying to connect to a Progress Database with a user_ID and password created (and with the permissions granted) through the SQL Explorer (SQL-92).
EXPLANATION:
This error is received when after creating the users and granting the permissions to the SQL-92 users with the Progress SQL Explorer the transactions were not commited.
By default the transactions are not commited when using the SQL Explorer.
SOLUTION:
To commit the transaction within the SQL Explorer:
**It's necessary to add the command "commit;" at the end of the transactions. For example:
create user 'user','password';
grant DBA to user;
commit;
**Or to tick the "Auto commit transactions" option in the "Connection Control" window (View menu->Options).