View previous topic :: View next topic
|
Author |
Message |
shreejita
New User
Joined: 16 Aug 2009 Posts: 60 Location: chennai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
shreejita
New User
Joined: 16 Aug 2009 Posts: 60 Location: chennai
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
sysibm.syspackauth |
|
Back to top |
|
|
Ragav86
New User
Joined: 27 Jan 2010 Posts: 37 Location: chennai
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
|