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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
