Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Security : Granting privileges : Privilege basics

Privilege basics

There are two types of privileges—those granted on databases and those granted on tables, views, and procedures.
Privileges for databases are:
*Granting or restricting system administration privileges (DBA)
*Granting audit privileges (audit administration, audit archive, or audit application insert)
*Granting or restricting general creation privileges on a database (RESOURCE)
Privileges granted on tables, views, and procedures grant or restrict operations on specific operations, such as:
*Altering an object definition
*Deleting, inserting, selecting and updating records
*Executing stored procedures
*Granting privileges
*Defining constraints to an existing table