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.

Regards,


Ann