Kbase P133711: SQL: How to revoke SQL privileges of the Default DBA?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/18/2009 |
|
Status: Verified
GOAL:
SQL: How to revoke SQL privileges of the Default DBA?
GOAL:
Who is the Default DBA of an OpenEdge / Progress database?
GOAL:
How to revoke SQL privileges ON PUB (data) tables from the user who created the database?
GOAL:
How to revoke SQL privileges ON system or virtual tables from the Default DBA?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1C
FIX:
The Default DBA of an OpenEdge / Progress database is the user who created that database. To revoke the Default DBA SQL privileges on one or more data, system or virtual tables, another DBA must first revoke the RESOURCE and DBA privileges of the Default DBA and use the GRANTED BY ANY_USER option of the REVOKE statement to revoke the specific privileges.
For example, to revoke all privileges on the customer table from the Default DBA named yshanshi, another DBA can execute the following two SQL statements:
REVOKE RESOURCE , DBA FROM yshanshi;
REVOKE ALL ON PUB.Customer FROM yshanshi GRANTED BY ANY_USER;
Where yshanshi is the Default DBA user who created the database.