Hi,
> Dear all,
> Though I don't have the same question as Roland, information below by Virna
> Constantin (costel_61@yahoo.com) is very useful.Thanks every one.
> Regards,Tjioe
>
> Suggestion
> event studies "on connect"
> 1. an application with minimum rights connects to the database
> 1 '. in table "mon$attachmnts" field "MON$REMOTE_PROCESS" will record the
> application name
> 2. in the trigger event "on connect" if the user connects SysAdmin, verifies
> the application name in "MON$REMOTE_PROCESS"
Just FYI: In practice it is possible to suppress database triggers (DPB: isc_dpb_no_db_triggers) when connecting as the database owner or as SYSDBA. E.g. isql has a special command-line option "-nodbtriggers" to bypass database triggers at connect time to e.g. modify/drop the trigger afterwards.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Posted by: "Thomas Steinmaurer" <ts@iblogmanager.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment