Kbase P11284: What SQL users exist in a database converted from version 8 to version 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/24/2008 |
|
Status: Verified
GOAL:
What SQL users exist in a database converted from version 8 to version 9
GOAL:
How can I define SQL permissions in a database converted from version 8 to version 9
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
FIX:
Databases which were created in version 8 and converted with the proutil tool to version 9 will only have the default sysprogress account in the SQL92 user lists.
This entry will not be enabled.
To make any changes to the permissions of the SQL92 side of the database will require activating this SYSPROGRESS account within the Data Dictionary and granting (then committing) permissions on the tables to valid operating system users within the SQL92 side of the database.
After the permissions have been granted and committed you can delete the sysprogress account from the Data Dictionary.
The permissions you have defined will still remain.
In a converted database with no database security defined, the sysprogress account is active as a default dba.
You can log in with sysprogress and no password and have DBA access.
In a converted database with security, the sysprogress account is inactive and needs to be activated.l
To activate the sysprogress account connect to the database with the Data Administration or Data Dictionary Tool.
Select the Admin menu and the Security menu option. Select Edit Users and add a sysprogress user.