Subject Re: [IBO] Re: How do I add a user using a stored procedure or through SQL Statements... ?
Author Jason Wharton
I have been wanting to get it setup in production but as of yet, the
application I have been trying to write for myself (to manage IBO sales and
source distribution, etc.) is on hold. Since I've known for quite some time
that InterBase has some security holes I have refrained from running a
publicly visible server. I have a special version on order from IBPhoenix so
as soon as they get it done I will have it ready to go.

What I have is a users table and a user action table. Triggers on the users
table feed the users action table. There is an after insert even on the user
action table and the service application that I have written listens for an
event of a user action. If it gets one it opens a query looking at the user
actions and performs them and deletes the action item. It is close enough to
real-time processing that as a user makes changes to the users table the
operations are carried out nearly instantly.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: <gsbrown@...>
To: <>
Sent: Monday, February 05, 2001 12:26 PM
Subject: [IBO] Re: How do I add a user using a stored procedure or through
SQL Statements... ?

> Jason,
> Do you have an example of this? Or can you explain further what it is
> that you do. My next application will require me to add users to the
> database.
> Thanks,
> Gerald S. Brown
> > What I like to do is use a service application that runs on the
> server that
> > is event driven (alerters) so that is all you have to do is change a
> value
> > in a table and it does the rest of the work for you.
> >
> > HTH,
> > Jason Wharton
> > CPS - Mesa AZ
> >