Subject Re: [firebird-support] SetUID stored procedures?
Author Ann W. Harrison
vandy899 wrote:
> I was just thinking, for some of the tables that I've made, it would
> be good if I could make it so that ordinary users could not SELECT *
> (for instance) on it, nor INSERT INTO, but could use stored procedures
> that *DO* do these things.

You don't need to do anything fancy like SETUID. Just grant privileges
to the procedures rather than users. The users get the privilege to
execute the procedure.