Usage Privilege

[stressman]

is there no solution to this problem :
how should i give the USAGE PRIVILIGE to users, to let them use a sequence that the admin creates

 

[gregsimpson]

Stressman,

not sure what you mean by sequence. Do you mean INSTANCE ?

 

[stressman]

no i really want to say sequence i create a sequence which increment a prinary key in a table

 

[stressman]

there is really no answer to this question.
Please I still need help

 

[gregsimpson]

Stressman,


Answer is

>>-GRANT--USAGE--ON SEQUENCE--sequence-name--TO PUBLIC---------><

Greg

 

[stressman]

If only things should be as easy as you tell if you succeded doing like this i've got to check the configuration of my DB2 environement

 

[stressman]

hello gregsimpson have you try the solution you gave me
i'm working under a w2k server with the DB2 version 7.2.0
the system successfully give the usage privilege to public BUT the users can not use the sequence they don't have the right to do it if you agree here's my personal e-mail:
vincent.m@m6net.fr thanks for your help

 

[gregsimpson]

Please follow the links at the bottom of this reply. They look likely to be the solution to your problem. It details a fix pack which you may need to install. Look at

JR16205 GRANT USAGE ON SEQUENCE DOES NOT BEHAVE CORRECTLY.
APAR Description:

PROBLEM SUMMARY: The values command returns SQL0551N error
even when the public is granted usage on the sequence..
.
db2 grant usage on sequence user1.seq1 to public
db2 connect to madinc user user2 using pwd
db2 values(nextval for user1.seq1) --> SQL0551N
TEMPORARY FIX: none
ERROR DESCRIPTION:
Grant usage on sequence behaves incorrectly. Here is a scenario
- db2 connect to madinc user user1 using pwd
- db2 create sequence seq1
- db2 grant usage on sequence user1.seq1 to public
- db2 connect to madinc user user2 using pwd
- db2 values(newtval for user1.seq1)
SQL0551N &quot;USER2&quot; does not have the privilege to perform operatio
n &quot;USAGE&quot; on object &quot;USER1.SEQ1&quot;. SQLSTATE=4501
LOCAL FIX:
none

http://dns1.supra.com.pl/download/db2_v7/fixes/win_pl/FP6_WR21299/APARLIST.TXT

http://www-4.ibm.com/cgi-bin/db2www...arlib.d2w/display_apar_details?aparno=JR16205