Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Grant access to DB2 objects

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jeevajeeva

New User


Joined: 13 May 2006
Posts: 17

PostPosted: Sat Jun 24, 2006 2:47 pm    Post subject: Grant access to DB2 objects
Reply with quote

hi,

how to grant access to all the storage groups,databases,plans,packages at one shot

i tried to use the following but it wont accept

grant all on package *.* to auth-id;

any please give me the correct code to do this
Back to top
View user's profile Send private message

Hanfur

Active User


Joined: 21 Jun 2006
Posts: 104

PostPosted: Tue Jul 04, 2006 5:14 pm    Post subject: Hi
Reply with quote

I must think that what you require is to issue GRANT all rights to all databases which comes under an Instance..

In that case Update Database confuguration file(INSTANCE level) to add those users in to any of the following user groups SYSCNTRL or SYSMAINT

-Han.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts RACF profile access vasanthz All Other Mainframe Topics 11 Fri Sep 23, 2016 5:51 am
No new posts How to perform Digest Access Authenti... vasanthz All Other Mainframe Topics 0 Tue Mar 15, 2016 4:47 pm
No new posts COFVLH02E VLF trimmed objects younger... Robert Sample All Other Mainframe Topics 2 Tue Feb 09, 2016 3:37 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us