Kbase 19780: 'Drop ' doesn't delete the from pub._sysdbauth Table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/01/2011 |
|
Status: Verified
SYMPTOM(s):
'Drop <user>' doesn't delete the <user> from pub._sysdbauth Table
Any attempt to delete the user with Delete sql causes error 8186
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Attempt to insert, update or delete a row in a schema table. (8186)
FACT(s) (Environment):
User remains in sysdbauth table after privileges are revoked.
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
OpenEdge Category: Database
CAUSE:
The existence of a user with a row in pub._sysdbauth (the base table for sysprogress.sysdbauth view) does not represent the possession of a db privilege by a user. The existence of a privilege is represented by the content of certain columns in _sysdbauth. The exact content and its meaning is not publicized for security reasons, and because it may change from release to release.
The error 8186 is apparent because no application is permitted to write to the OpenEdge schema tables. The only way to change the content of pub._sysdbauth is via GRANT and REVOKE commands.
FIX:
The rows with users that you are perfectly OK. If you revoked privileges from a user, the revoked user privileges have in fact been revoked and no longer exist.