Try OpenEdge Now
skip to main content
SQL Development
Data Control Language and Security

Data Control Language and Security

The OpenEdge SQL Data Control Language (DCL) provides security for your database. The DCL consists of the GRANT, REVOKE, COMMIT, and ROLLBACK statements. GRANT and REVOKE statements enable you to determine whether a user can view, modify, add, or delete database information.
This chapter covers the GRANT and REVOKE statements. COMMIT and ROLLBACK are covered in Data Control Language and Transaction Behavior.
Note: This chapter gives an overview of DCL statements. For complete syntax of each statement, see OpenEdge Data Management: SQL Reference.
* Working with database security
* Creating users
* Granting privileges
* Verifying privileges
* Revoking privileges