|
View previous topic :: View next topic
|
| Author |
Message |
rakesh1155
New User
Joined: 21 Jan 2009
Posts: 84
Location: India
|
|
|
|
Hi,
What is the correct syntax to change the current qualifier as userx instead of the current login-id.
Please correct the following:
SET CURRENT SQLID = 'userx';
-Thanks,
Rakesh. |
|
| Back to top |
|
 |
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
Hi Rakesh
Your statement is valid if the 'userx' is the primary logn-id or it is one of the secondary authorization id.
Regards
Raghu |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Rakesh,
Don't forget to put COMMIT ; stmt after running the above stmt. |
|
| Back to top |
|
|
|
|
