MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DB2 v7 on Z.OS Privilges

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> DB2/IMS
View previous topic :: View next topic  
Author Message
Manas Biswal
Intermediate


Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India

PostPosted: Mon Dec 05, 2005 11:44 am    Post subject: DB2 v7 on Z.OS Privilges Reply with quote

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)
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> DB2/IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group