IBM Books

Types of authorization

There are two types of authorization--privileges and authorities. A privilege is the right to access a specific database object in a specific way. For example, the UPDATE privilege on a table is the right to change an entry in the table. An authority is the right to exercise multiple privileges, or perform operations, or both, on a database or its objects. For example, DBADM authority includes the right to exercise all privileges on a database's objects and to perform such operations as creating event monitors and reorganizing tables. For more about authorizations, see "Controlling Database Access" in the Administration Guide and the sections on GRANT statements in the SQL Reference.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]