DCL Statements

The BNF notations for the main two DCL statements are:

GRANT {[ALL [PRIVILEGES]] | <privilege,...>}
[ON <object_name>]
TO <user_group_or_role>
[WITH GRANT OPTION] 
REVOKE {[ALL [PRIVILEGES]] | <privilege,...> 
ON <object_name>
FROM <user_group_or_role>

BackCover

SQL Bible

Preface

Part II: Creating and Modifying Database Objects

Part III: Data Manipulation and Transaction Control

Part V: Implementing Security Using System Catalogs

Part VII: Appendix

Appendix A: What's on the CD-ROM

Appendix B: The ACME Sample Database

Appendix C: Basics of Relational Database Design

Appendix D: Installing RDBMS Software

Appendix E: Accessing RDBMS

Appendix F: Installing the ACME Database

Appendix G: SQL Functions

Appendix H: SQL Syntax Reference

DDL Statements

DCL Statements

DML Statements

DQL Statements

Transactional Control Statements

Predicates

Appendix I: SQL-Reserved Keywords

Appendix J: SQL99 Major Features Compliance Across Different RDBMS

Appendix K: The Other RDBMS

Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory

List of Figures

List of Tables

List of Code Examples

List of Sidebars

CD Content