Re: how to grant select on table using trigger

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 users. thats why i thought to grant
> permission by trigger.

Do you have control over how the application works?  Is it possible
to configure or modify the application to issue the appropriate
GRANTs?

> i know the newly created table name is listed in one Table called
> queries.  can you pls write sample code so that i can grant permission
> on tables created by application

I *did* show sample code.  If it doesn't work for you then please
provide more information, like any error messages that resulted.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/