Re: User permissions
От | tony |
---|---|
Тема | Re: User permissions |
Дата | |
Msg-id | 1015942019.5496.3.camel@vaio обсуждение исходный текст |
Ответ на | User permissions ("Lars Preben S. Arnesen" <l.p.arnesen@usit.uio.no>) |
Ответы |
Re: User permissions
|
Список | pgsql-general |
On Tue, 2002-03-12 at 14:49, Lars Preben S. Arnesen wrote: > I'm writing a web application to access a Postgres database. I want > the application to use a user with limited permissions - it should > only be able to execute predefined functions in the database. > > I have been searching for the Postgres-way of doing this, but I din't > find any solution. > > I have designed functions with pl/pgsql which do alter, insert, select > and delete in the database, but I don't want the database user to be > able to perform these actions without using the predefined functions. > > How can I do this? What middleware are you using? If you are using Java/JSP then you fix the permissions at the web page level. Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
В списке pgsql-general по дате отправления: