Re: [SQL] Execute permsissions on fuctions

2001-08-25 Thread Christopher Sawtell
On Sat, 25 Aug 2001 16:42, Zot O'Connor wrote: > Christopher Sawtell wrote: > > On Fri, 24 Aug 2001 06:52, Zot O'Connor wrote: > > > Other SQL servers have the concept of stored procedures having > > > different permissions. > > > > > > For instance a procedure that can update a table. > > > > > >

Re: [SQL] Execute permsissions on fuctions

2001-08-24 Thread Dmitry G. Mastrukov
23 Aug 2001 11:52:25 -0700, Zot O'Connor > Other SQL servers have the concept of stored procedures having different > permissions. > > For instance a procedure that can update a table. > > Since a web site typically connects as the webuser (or equiv postgres > user), I do not want to offer

Re: [SQL] Execute permsissions on fuctions

2001-08-24 Thread Zot O'Connor
Christopher Sawtell wrote: > > On Fri, 24 Aug 2001 06:52, Zot O'Connor wrote: > > Other SQL servers have the concept of stored procedures having different > > permissions. > > > > For instance a procedure that can update a table. > > > > Since a web site typically connects as the webuser (or equi

[SQL] Execute permsissions on fuctions

2001-08-23 Thread Zot O'Connor
Other SQL servers have the concept of stored procedures having different permissions. For instance a procedure that can update a table. Since a web site typically connects as the webuser (or equiv postgres user), I do not want to offer update to the webuser. The way I have done this elsewhere i