#1: DB2 v7 on Z.OS Privilges Author: Manas Biswal, Location: Chennai, IndiaPosted: Mon Dec 05, 2005 11:44 am Hello Forum,
After the post on DB2 on Z/OS authorities, I thought of putting together another post on privileges. DB2 privileges are much more granular than authorities and unlike authorities, they are granted at a DB2 object level. Some of the DB2 authorities can be thought of as an encapsulation of a group of privileges.
Following are most of the DB2 privileges that you are expected to encounter on DB2 v7 on Z/OS. They are grouped according to the object on which they apply.
Table
Select
Alter
Delete
Index
Insert
References
Trigger
Plan/Package
Bind (Bind/Rebind/Free)
Execute
Collection
Createin
Database
Createtab
CreateTS
DisplayDB
Drop
Imagcopy
Load
Recoverdb
Reorg
Repair
Startdb
Stats (Runstats and Check utilities)
Stopdb