Release 10.1A: OpenEdge Data Management:
SQL Development

> ## Data Control Language and Security

> The 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 Chapter 8, " Data Control Language and Transaction Behavior."

> This chapter contains the following sections:

> - Working with database security

> - Creating users

> - Granting privileges

> - Verifying privileges

> - Revoking privileges

> Note: This chapter gives an overview of DCL statements. For complete syntax of each statement, see OpenEdge Data Management: SQL Reference .

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095