Hi,

I am writing a program that updates our customers using script
files, this works fine for most things, however if we add a new
table to the database obviously we need to grant rights to the
existing users, but as we are unaware what users exist the only way
I could see to do it is to grant rights in a stored procedure.

Is there anyway I can do this?

I am reluctant to change my program to incorporate this as it is
designed to be as generic as possible.

TIA

Adam Stewart
Lynx Express Ltd