Kbase P91081: How to revoke a SQL92 user right to update the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/08/2008 |
|
Status: Verified
GOAL:
How to revoke a user right to update the database?
GOAL:
How to revoke permissions using SQL-92
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Revoke - Revokes various privileges from specified user(s) of the database. There are two forms of the REVOKE statement.
Revoke database_wide privileges, either system administration (DBA), or general creation (RESOURCE), or both.
Revoke various privileges on specific tables and views.
This is syntax to REVOKE system administration privileges (DBA) or general creation privileges (RESOURCE), or both:
SYNTAX:
REVOKE { RESOURCE , DBA } FROM { username [ , username ] , ... } ;
RESOURCE
Revokes from the specified users the privilege to issue CREATE statements.
DBA
Revokes from the specified users the privilege to create, access, modify, or delete any database object, and revokes the privilege to grant other users any privileges.