Kbase 21703: Cannot Revoke Permissions Granted by the Default DBA
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2009 |
|
Status: Verified
SYMPTOM(s):
DBA cannot revoke user Privileges granted by the default DBA (creator).
Default DBA\Creator has been deactivated.
FACT(s) (Environment):
SQL-92 ODBC Driver
SQL-92 JDBC Driver
Progress 9.1x
OpenEdge 10.1x
CAUSE:
Permission granted by the default DBA (the user who created the database) to other users cannot be revoked by the newly created DBA's. The user who creates the database becomes the default DBA. This user can be used to set additional database Administrator accounts. When users are created in the database, the default DBA (the user who created the database) becomes disabled. Any permission granted by the default DBA (the user who created the database) to other users cannot be revoked by the newly created DBA's. It is important to grant DBA access to at least one user in order to have a valid DBA account.
FIX:
To make changes to the permissions granted by the default DBA, Connect to the database using SQL Explorer with the new DBA account. Add the user name of the default DBA (the user who created the database) and give it DBA permissions. Use the following SQL statement:
create user 'User','password';
grant dba to 'User';
commit;
Replace 'User' with the name of the Creator of the database. Once this is done, simply reconnect to the database with the default DBA (the user who created the database). Privileges that were originally set by the default DBA can now be manipulated.