View previous topic :: View next topic |
Author |
Message |
culturewyj Beginner
Joined: 15 Jun 2006 Posts: 15 Topics: 10
|
Posted: Wed Jul 05, 2006 10:03 am Post subject: bind unsucessful. |
|
|
Code: | READY
DSN SYSTEM(DB7G)
DSN
BIND PACKAGE (PX27) MEMBER(PX27DB2) ACT(REP) ISO(CS) ENCODING(EBCDIC) OWNER
DSNT235I -DB7G DSNTBCM2 BIND AUTHORIZATION ERROR
USING PX27 AUTHORITY
PACKAGE = TONGJILP2V7.PX27.PX27DB2.()
PRIVILEGE = CREATE IN
DSNT233I -DB7G UNSUCCESSFUL BIND FOR
PACKAGE = TONGJILP2V7.PX27.PX27DB2.()
DSN
BIND PLAN(PX27) PKLIST(PX27.*) ACT(REP) ISO(CS) ENCODING(EBCDIC) OWNER(PX27
DSNT241I -DB7G BIND AUTHORIZATION WARNING ON PLAN PX27
AUTHORIZATION-ID PX27 NOT AUTHORIZED TO EXECUTE
PACKAGE PX27.*
DSNT252I -DB7G DSNTBCM1 BIND OPTIONS FOR PLAN PX27 |
when i try to bind,it reported me those messages.' i query the sysibm.sysuserauth system catalog table, i found the value for BINDADDAUTH is 'Y', any wrong with it? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12355 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
CZerfas Intermediate
Joined: 31 Jan 2003 Posts: 211 Topics: 8
|
Posted: Thu Jul 06, 2006 1:48 am Post subject: |
|
|
Well, no. Actually he needs the right to create packages in the colletion PX27. BINDADD is already granted.
Kolusu, could you provide a link to the point in the DB2 manuals, where the grants for using collections are discussed?
regards
Christian |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12355 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|