Set session authorization

Hello everyone, i setup DB2 9.1.0 on the same windows 2003 machine where DOMINO 8.5 is running.

I can create ACCESS VIEW and QUERY VIEW, but when I try to open the QUERY VIEW from the client i still get the folloqing error:

"

server5/ACME/IT

Failed when DB2 was selecting a note. DB2 NSF failure.: 28000 - [IBM][CLI Driver][DB2/NT] SQL0552N “USERX” non dispone del privilegio per eseguire l’operazione “SET SESSION AUTHORIZATION”. SQLSTATE=28000 - *LOCAL.DB2.090803124540(nserver)

"

Please, anyone can help me… it’d be much much appreciated i’m just stuck since too much time with this and i’ve got no clue on what to do next to sort it out!

Subject: Re: SET SESSION AUTHORIZATION

It appears that some of the setup steps for Domino’s DB2 account were not done properly. Please revisit this part of the setup, and that should take care of it:

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.help.domino.admin.doc/DOC/H_ASSIGNING_SETSESSIONUSER_PRIVILEGE_TO_THE_DOMINO_SERVER_USER_STEPS.html

Subject: yep!

yes Patrick, you’re right!

now it’ working fine !! thank you very much!

I appreciated your help!

Marco