MVSFORUMS.com

[Manas Biswal]

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

Subsystem

Archive (Archive Log, Display Archive, Set Log, Set Archive)
Bindadd
BSDS
Createalias
createDBA
Recover
Stopall
stospace
trace
Createdbc
CreateESG
Createtmtab
Display
Monitor1
Monitor2

Use

Use of Bufferpool
Use of Stogroup
Use of Tablespace

Schema

Createin
Alterin
Dropin

Routine

Execute on function
Execute on procedure

The DB2 v7 Administration guide has the details of all the above mentioned privileges -

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/CCONTENTS

If anybody still has any doubts on any privileges, please feel free to post it on the DB2 forum.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)