At 15:22 08/08/2001, you wrote:

>Now this is a whole different kettle of fish altogether!
>
>Sounds like you need to update the user's GRANT and REVOKE status on a set
>of databases based on their permissions which are maintained in a control
>database. This does not sound like a very dynamic situation so it should
>not require triggers.
>
>My suggestion would be to write a separate application which maintains user
>GRANT/REVOKE permissions in the control database and then propagates these
>to the other database. When a new user is added to the database do it
>through this application.
>
>P.S. Stop thinking about using UDFs for this. It will not work well, if at
>all! Your idea that it will is an illusion.
>
>Hope this helps!

It does help - since the main program runs packages, the best solution
might be to remove the user manager from the main prog and make a package
out of it, it would also make future changes easier

Thanks


Damian Dowling
IT Manager
Pallas Foods Ltd

Phone: + 353 69 20200
Fax: + 353 69 20201
Email: it-manager@...