Prev: Yellowfin launches its Business Intelligence application for the iPhone
Next: Need HowTo for using included TSA on windows platform
From: mxb1c on 7 Dec 2009 18:36
Hi all,

Does anyone have experience with impersonation within stored
procedures? I would like to impersonate current user to admin user
then do some privilege assignment work and then impersonate back to
original user. Any suggestions?

Regards,

Mehmet


From: Sawan on 7 Dec 2009 22:25
On Dec 8, 4:36 am, mxb1c <mbaser...(a)gmail.com> wrote:
> Hi all,
>
> Does anyone have experience with impersonation within stored
> procedures?  I would like to impersonate current user to admin user
> then do some privilege assignment work and then impersonate back to
> original user. Any suggestions?
>
> Regards,
>
> Mehmet

Have you looked at Trusted Context, Switching User

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com..ibm.db2.luw.qb.dbconn.doc/doc/t0023258.html

HTH
Sawan Gupta
 | 
Pages: 1
Prev: Yellowfin launches its Business Intelligence application for the iPhone
Next: Need HowTo for using included TSA on windows platform