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 

question about the AUTH of bind

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
issac1029
Intermediate


Joined: 10 Dec 2005
Posts: 159
Topics: 75
PostPosted: Sun Aug 27, 2006 6:05 am    Post subject: question about the AUTH of bind Reply with quote
Hi all,

which ibmsystem table shows the AUTH of a id to bind? I only find a table about the AUTH to update and alter. Pls help me,thanks
Back to top
View user's profile Send private message Send e-mail MSN Messenger
bauer
Intermediate


Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
PostPosted: Mon Aug 28, 2006 5:37 am    Post subject: Reply with quote
I'm not sur eabout your question.

If you are talking about the auhorization to do binds then column BINDADDAUTH in table SYSIBM.SYSUSERAUTH my be the column you are looking for.

What is excactyl your request ?


regards,
bauer
Back to top
View user's profile Send private message
shekar123
Advanced


Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
PostPosted: Mon Aug 28, 2006 10:07 am    Post subject: Reply with quote
issac1029,

In this case GY ID has given Bind Authority to my User Id.Hope this helps:
Code:

SELECT * FROM SYSIBM.SYSUSERAUTH WHERE GRANTEE = 'SHEKAR';                     
---------+---------+---------+---------+---------+---------+---------+--------------
GRANTOR   GRANTEE   TIMESTAMP     DATEGRANTED  TIMEGRANTED  GRANTEETYPE  BINDADDAUTH
---------+---------+---------+---------+---------+---------+---------+--------------
GY        SHEKAR    C8888N3ZA2IB  051025       17572701                  Y

_________________
Shekar
Grow Technically
Back to top
View user's profile Send private message
issac1029
Intermediate


Joined: 10 Dec 2005
Posts: 159
Topics: 75
PostPosted: Fri Sep 08, 2006 8:03 am    Post subject: Reply with quote
I try that, but do not have auth to inqury~
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database 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