[Please copy the mailing list when you reply.]
On Sat, Jan 08, 2005 at 01:09:29AM -0800, santosh dwivedi wrote:
> I re-written the trigger and function like , run time it gives the following
> warning
> WARNING: Error occurred while executing PL/pgSQL function permitselect
> WARNING: line 2
On Fri, Jan 07, 2005 at 02:33:50AM -0800, santosh dwivedi wrote:
> i want to use trigger because my one of application connects to
> databse and creates tables in database dynamically , other user
> want to acces it . as when application creates table in databse it
> does not GRANT select to other
Hi
i want to use trigger because my one of application connects to databse and creates tables in database dynamically , other user want to acces it . as when application creates table in databse it does not GRANT select to other users. thats why i thought to grant permission by trigger.
i know t
On Fri, Jan 07, 2005 at 12:30:16AM -0800, santosh dwivedi wrote:
> i want to grant select permission to a group on table that will
> be created by me in future. so i used trigger and a function
Why use a trigger? Why not just issue a GRANT statement when you
create the table? What problem are
HI
I am using postgersql and i am newbie,
i want to grant select permission to a group on table that will be created by me in future.
so i used trigger and a function
CREATE FUNCTION permitselect () RETURNS opaque AS 'DECLARE BEGIN GRANT SELECT ON NEW to GROUP wp; RETURN NEW; END; ' LANGUA
