Kbase P12281: Unable to add SQL-92 users to converted database with security
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/2008 |
|
Status: Verified
SYMPTOM(s):
Unable to add SQL-92 users to database
Schema security (can-read, can-write) on 4GL database engine prevents SQL access to set up sysprogress account
With schema security disabled, SQL/ODBC/JDBC can access database, but 4GL users are unable to do so because schema security tied to application code (triggers).
FACT(s) (Environment):
Progress 9.1X
OpenEdge 10.x
All Supported Operating Systems
CHANGE:
Database migrated from Progress 8 to Progress 9 via convert 8/9
CAUSE:
8/9 converted database needs to have the sysprogress account enabled in order to add SQL-92 users to the database. The sysprogress account can not be created if schema security exists.
FIX:
1. Remove schema security (can-read, can-write).
2. Log into Data Dict./Admin/Security with the user that controls schema and create a sysprogress account with a password.
3.Access the database via SQL Explorer with the newly created sysprogress account (the database default dba account) and create users and grant them the proper permissions to SELECT, DELETE, etc.
4. Go back into the Data Dict/Admin/Security and delete the sysprogress account.
5. Re-enable schema security for 4GL users.