|
Home > Archive > SQL Anywhere database > April 2005 > ConnectFailed Event
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ConnectFailed Event
|
|
| David DeRam 2005-04-21, 8:23 pm |
| If I create an event for ConnectFailed and I do an SQL select and an SQL
update in the event (like the ConnFail event in the documentation for the
LOGIN_PROCEDURE option) what user account executes the SQL command? If
there is no connection can I run selects and updates to tables?
| |
| Bruce Hay 2005-04-22, 9:23 am |
| Events run as the user that created them, similar to the way procedures
operate.
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"David DeRam" < ns_xxxdderam@progeny
ns_xxx2000.com> wrote in message
news:4268431f$1@foru
ms-2-dub...
> If I create an event for ConnectFailed and I do an SQL select and an SQL
> update in the event (like the ConnFail event in the documentation for the
> LOGIN_PROCEDURE option) what user account executes the SQL command? If
> there is no connection can I run selects and updates to tables?
>
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-04-22, 8:23 pm |
| This is covered in the documentation for CREATE EVENT and is as follows:
"Event handlers execute on a separate connection, with the permissions of
the event owner. To execute with permissions other than DBA, you can call a
procedure from within the event handler: the procedure executes with the
permissions of its owner. The separate connection does not count towards the
ten-connection limit of the personal database server."
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com
********************
********************
********************
*****************
"David DeRam" < ns_xxxdderam@progeny
ns_xxx2000.com> wrote in message
news:4268431f$1@foru
ms-2-dub...
> If I create an event for ConnectFailed and I do an SQL select and an SQL
> update in the event (like the ConnFail event in the documentation for the
> LOGIN_PROCEDURE option) what user account executes the SQL command? If
> there is no connection can I run selects and updates to tables?
>
>
>
|
|
|
|
|