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
 

 

BINDADD privilege

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

New User


Joined: 16 Aug 2009
Posts: 60
Location: chennai

PostPosted: Mon May 17, 2010 12:27 pm    Post subject: BINDADD privilege
Reply with quote

My shop has installed my plan name and package name to DB2 where i can see my plan name and package name thru SYSIBM.SYSPACKLIST. but when i bind thru BINDJCL is it showing BINDADD privilege not successful..

Help me
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Mon May 17, 2010 12:58 pm    Post subject: Reply to: BINDADD privilege
Reply with quote

Help me

what does the message
Quote:
but when i bind thru BINDJCL is it showing BINDADD privilege not successful..
hint You?
how do You expect us to be able to help You ???
speak to Your support
Back to top
View user's profile Send private message
shreejita

New User


Joined: 16 Aug 2009
Posts: 60
Location: chennai

PostPosted: Mon May 17, 2010 5:02 pm    Post subject:
Reply with quote

I am changing the question earlier i asked to this ways

How can I check whether a user has BINDADD authority or not ???

Is there any SQL available????
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Mon May 17, 2010 6:08 pm    Post subject:
Reply with quote

sysibm.syspackauth
Back to top
View user's profile Send private message
Ragav86

New User


Joined: 27 Jan 2010
Posts: 37
Location: chennai

PostPosted: Tue May 18, 2010 5:08 pm    Post subject: Reply to: BINDADD privilege
Reply with quote

Code:

GET AUTHORIZATIONS;



use this command in spufi or command editor i can get these details
Code:

------------------------------ Commands Entered ------------------------------
get authorizations;
------------------------------------------------------------------------------
get authorizations

 Administrative Authorizations for Current User

 Direct SYSADM authority                    = NO
 Direct SYSCTRL authority                   = NO
 Direct SYSMAINT authority                  = NO
 Direct DBADM authority                     = YES
 Direct CREATETAB authority                 = YES
 Direct BINDADD authority                   = YES
 Direct CONNECT authority                   = YES
 Direct CREATE_NOT_FENC authority           = YES
 Direct IMPLICIT_SCHEMA authority           = YES
 Direct LOAD authority                      = YES
 Direct QUIESCE_CONNECT authority           = YES
 Direct CREATE_EXTERNAL_ROUTINE authority   = YES
 Direct SYSMON authority                    = NO

 Indirect SYSADM authority                  = YES
 Indirect SYSCTRL authority                 = NO
 Indirect SYSMAINT authority                = NO
 Indirect DBADM authority                   = NO
 Indirect CREATETAB authority               = YES
 Indirect BINDADD authority                 = YES
 Indirect CONNECT authority                 = YES
 Indirect CREATE_NOT_FENC authority         = NO
 Indirect IMPLICIT_SCHEMA authority         = YES
 Indirect LOAD authority                    = NO
 Indirect QUIESCE_CONNECT authority         = NO
 Indirect CREATE_EXTERNAL_ROUTINE authority = NO
 Indirect SYSMON authority                  = NO


SQLCODE: 0


try this above command some time you may not have authorization to use this command also.
can any one suggest any query to see the list of authorization like above?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Tue May 18, 2010 5:46 pm    Post subject:
Reply with quote

GET AUTHORIZATIONS is a LUW command and I don't think it exists on z/OS.

Even on LUW it is deprecated http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.wn.doc/doc/i0051325.html

and replaced by
ONLY LUW
Code:
SELECT AUTHORITY, D_USER, D_GROUP, D_PUBLIC, ROLE_USER, ROLE_GROUP, ROLE_PUBLIC, D_ROLE
   FROM TABLE (SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID ('johndoe', 'U') ) AS T
   ORDER BY AUTHORITY
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 TABLE-SPACE DROP PRIVILEGE Question Amit Suri DB2 3 Sat Jul 31, 2010 6:00 pm


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