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
 

 

doubt on GRANT

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

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Thu Dec 29, 2005 12:40 pm    Post subject: doubt on GRANT
Reply with quote

Dear Experts,

Plz clear my doubt......

i'm giving grant option to xxx

GRANT ALL PRIVILAGES ON KUMAR.EMP TO XXX WITH GRANT OPTION.

xxx is granting to YYY

GRANT SELECT ON KUMAR.EMP TO YYY.

some time later ....KUMAR is revoking the GRANT from XXX
is it possible, if so will the YYY retain the grant on select kumar.emp.

its urgent...

kumar.p.v
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Dec 29, 2005 1:11 pm    Post subject:
Reply with quote

No
Back to top
View user's profile Send private message
kumar_ngl
Warnings : 1

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Thu Dec 29, 2005 4:09 pm    Post subject:
Reply with quote

dear guptae,

I didn;t get the clear pic about your answer "No"..Please gimme a detailed explantaion if possible...thanx

kumar.p.v
Back to top
View user's profile Send private message
anilbatta

New User


Joined: 13 Nov 2005
Posts: 22

PostPosted: Thu Dec 29, 2005 5:21 pm    Post subject:
Reply with quote

Hi

I Think the GRANT permissions will be given only by the Database administrator and not be given by the users.

Suppose, if you are the Database Administrator, then you can grant the permission like this:

GRANT SELECT ALL FROM KUMAR.EMP to TTT
IN (GRANT SELECT FROM KUMAR.EMP TO YYY);

Try this out and let's check whether this will work or not.
And moreover be clear on the question you provide to the users.

Regards
Anilbatta
Back to top
View user's profile Send private message
nikyojin

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Thu Dec 29, 2005 8:47 pm    Post subject: Re: doubt on GRANT
Reply with quote

Hi Kumar,
Only the System Database Administrator has the Highest privilege to provide "Grant Authority".
But as per ur query suppose Kumar is the DB Admin. Hence if Kumar revokes the Grant option from TTT all the Privileges provided by TTT will be revoked. So YYY will not retain the select option.
This is my logical explanation....Let's hope we get some further help from our forum friends.....
Back to top
View user's profile Send private message
yeshao

New User


Joined: 28 Dec 2005
Posts: 2

PostPosted: Fri Dec 30, 2005 6:49 am    Post subject: Re: doubt on GRANT
Reply with quote

Hi

The WITH GRANT OPTION clause of the GRANT statement allows an ID to pass the granted privilege to others. If the privilege is removed from the ID, its deletion can cascade to others. When a privilege is removed from authorization ID TTT, it is also removed from any ID to which TTT granted it, unless that ID also has the privilege from some other source.
An ID with SYSADM or SYSCTRL authority can revoke a privilege that has been granted by another ID.
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 Doubt in MFS abdulrafi IMS DB/DC 2 Fri Oct 21, 2016 3:09 pm
No new posts Doubt on GETMAIN, FREEMAIN behaviour Arunkumar Chandrasekaran CICS 3 Sun Aug 30, 2015 9:22 pm
No new posts Doubt in using command code O Appu IMS DB/DC 4 Tue Jan 13, 2015 3:14 pm
No new posts Doubt in using command code D and N t... Appu IMS DB/DC 7 Mon Dec 29, 2014 5:52 pm
This topic is locked: you cannot edit posts or make replies. ISREDIT macro command doubt sakrat TSO/ISPF 60 Wed Feb 05, 2014 6:47 pm


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