Kbase P132515: SQL: How to REVOKE SELECT ON SYSPROGRESS.SYSDBAUTH FROM SYSPROGRESS user?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/11/2010 |
|
Status: Verified
GOAL:
SQL: How to REVOKE SELECT ON SYSPROGRESS.SYSDBAUTH FROM SYSPROGRESS user?
GOAL:
How to REVOKE RESOURCE and DBA privileges FROM SYSPROGRESS user?
GOAL:
SQL: How to REVOKE SELECT ON SYSPROGRESS owned tables?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
FIX:
Connect to the database as the default Database administrator (DBA) who created the database. Use a JDBC client like the Progress SQL Explorer Tool or Minq Software DBVisualizer Tool to execute the following following SQL statements:
REVOKE RESOURCE, DBA FROM SYSPROGRESS;
REVOKE SELECT ON SYSPROGRESS.SYSDBAUTH FROM SYSPROGRESS;
COMMIT WORK;
If you are using an ODBC client like the Microsoft ODBCTest Tool or the Synametrics Technologies WinSQL Tool to execute the same statements with the following slightly different syntax:
REVOKE RESOURCE, DBA FROM SYSPROGRESS
REVOKE SELECT ON SYSPROGRESS.SYSDBAUTH FROM SYSPROGRESS
GO
Notice that we need to first revoke the REVOKE RESOURCE and DBA privileges FROM SYSPROGRESS before REVOKE his SELECT privilege ON SYSPROGRESS.SYSDBAUTH or indeed any SYSPROGRESS owned table.