[firebird-support] On Connect triggers are dangerous, aren't they?

[[e-mail] [firebird-support]]

Hi!

I am reading message Yahoo! Groups https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876

https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876

Yahoo! Groups https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876 > SYSDBA users can see other connected users using monitoring tables > but is it possible to implement such feature for non-SYSDBA users? Are



View on beta.groups.yahoo.com https://beta.groups.yahoo.com/neo/groups/firebird-support/conversations/messages/129876
Preview by Yahoo


and I wonder is there mechanism to prevent this trigger become dangerous. E.g. if there is the slightest chance that error will be thrown in the on connect trigger then the database will be completely unavailable. When any block can be solution, but it is not 100% either. Some uneasiness is about using on connect trigger feature...


J.

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by ***@yahoo.dk [firebird-support]
I wonder is there mechanism to prevent this trigger become dangerous. E.g. if there is the
slightest chance that error will be thrown in the on connect trigger then the database
will be completely unavailable.

Not quite so. SYSDBA can log in with DB triggers disabled and fix/deactivate them.
--
WBR, SD.


------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

['Paul Beach' [e-mail] [firebird-support]]

<<and I wonder is there mechanism to prevent this trigger become dangerous. E.g. if there is the slightest chance that error will be
thrown in the on connect trigger then the database will be completely unavailable. When any block can be solution, but it is not
100% either. Some uneasiness is about using on connect trigger feature...>>

gbak -nodbtriggers - Suppresses Database Triggers from running [Firebird 2.1]

Regards
Paul Beach