Kbase P131494: SQL: Is there a way to reset a Progress database to its original state after the execution of GRANT,
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/05/2008 |
|
Status: Unverified
GOAL:
SQL: Is there a way to reset a Progress database to its original state after the execution of GRANT, REVOKE, CREATE USER, etc?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The only way to truly revert a Progress database to its original state after the execution of permission and security related SQL statements like GRANT, REVOKE, and CREATE USER is to restore it from an existing database backup.
Without restoring from a backup, the closest thing one can get to such a reversal is to execute SQL statements to undo all the actions originally taken. For example, use a REVOKE action to undo every GRANT action, etc.
Even this procedure will not completely revert the database to its original state. For example, doing a GRANT followed by a REVOKE reversal of that GRANT will revoke the privileges granted but will keep the user name in the SYSPROGRESS.SYSDBAUTH table regardless of whether that user exists in the _user table or not.