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
 

 

How to Grant only Rebind previleages to a package?

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

New User


Joined: 06 May 2009
Posts: 4
Location: Bangalore

PostPosted: Tue Sep 29, 2009 3:46 pm    Post subject: How to Grant only Rebind previleages to a package?
Reply with quote

Hi,

I need to grant Rebind access to certain group(a1).

We have multiple regions and each region is associated with their own DB, say a1, a2,a3, a4 etc..each regions are inter-dependent.
To elaborate:
a1 uses the tables associated in other regions and so are bound with packages of a2, a3 etc... but a1 doesn't have privileges to bind packages of a2 or a3, so i need to provide bind access to a1 on a2 and a3.
which i can easily perform;

set current sqlid=a2
grant bind on package a2.x to a1;

But only a2 and a3 should be the owners and have exclusive access on their objects. so i need to provide only rebind access to a1,
so is their any command that helps me to give a1 only the rebind access and not the full bind or any other access.

please suggest asap.

Thanks,
Vinay
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 29, 2009 4:27 pm    Post subject:
Reply with quote

Search on word "Grant" under DB2 part of the Forum. Work through the links you find there, that would be ASAP.
Back to top
View user's profile Send private message
vinaya kumar

New User


Joined: 06 May 2009
Posts: 4
Location: Bangalore

PostPosted: Tue Sep 29, 2009 5:11 pm    Post subject:
Reply with quote

Thanks Anuj,

Appreciate your reply.

After running thru' the forum, unable to find specific grant on rebind alone, I did post the request.

So Appreciate if you can reply, if you know about the same.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Sep 30, 2009 3:38 pm    Post subject:
Reply with quote

Hi Vinay,

From the way i understand a1, a2, a3 & a4 are collections and x happens to be the package.

You are granting a bind privilege of collection/packages to another collection. Can you tell me by doing this what can you do ?

By the way BIND privilege includes BIND/REBIND/FREE. There is no separate privilege for REBIND alone.

Can you elaborate your requirement, a bit more. It will be easy for the experts here to help you.

Thank You,
Sushanth
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 JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts Cobol DB2 package accessing differen... Mainak_Dalal DB2 1 Tue Jan 26, 2016 12:57 am
No new posts Can not find SQL statement of package... chaoj DB2 2 Wed Mar 11, 2015 12:00 pm


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