Re: Can I fire a trigger on the connect event?

Hello !

We have done like this :

1. Create a role with password that have all necessary privileges for your application.
2. Store the password encrypted in a table.
3. Grant SELECT to that table to all users or public.
4. When the user start the application and are connected successfully the application retrieve the password for the role and execute the command 'SET ROLE r_some_role IDENTIFIED BY password;' without notifications to the user.

Hope this helps you
/Ulf

Dave Mattie wrote in message <35AE5033.AF4B4A00_at_nbnet.nb.ca>...
>We're trying to establish some security around our applications.
>I want to be able to allow a user to connect only from certain
>applications and exclude everything else.
>Anyone have any Ideas?
>
>David_Mattie_at_DMR.CA
>
Received on Fri Jul 17 1998 - 10:14:30 CEST