Re: [GENERAL] create user with database and contrib

2005-04-09 Thread Tom Lane
Oleg Bartunov writes: > On Sat, 9 Apr 2005, Michal Hlavac wrote: >> ok, I can add ltree via superuser, but I must grant access for user >> diplo to every function... > Did you try what I recommend you ? It should works Dunno about ltree, but I have found that the default installation of tsearch2

Re: [GENERAL] create user with database and contrib

2005-04-09 Thread Bruno Wolff III
On Sat, Apr 09, 2005 at 15:19:58 +0200, Michal Hlavac <[EMAIL PROTECTED]> wrote: > Oleg Bartunov wrote: > > so, what's the problem ? psql diplo < ltree.sql > > ok, I can add ltree via superuser, but I must grant access for user > diplo to every function... > > it is possible to do that easier?

Re: [GENERAL] create user with database and contrib

2005-04-09 Thread Oleg Bartunov
On Sat, 9 Apr 2005, Michal Hlavac wrote: Oleg Bartunov wrote: so, what's the problem ? psql diplo < ltree.sql ok, I can add ltree via superuser, but I must grant access for user diplo to every function... it is possible to do that easier? Did you try what I recommend you ? It should works -

Re: [GENERAL] create user with database and contrib

2005-04-09 Thread Michal Hlavac
Oleg Bartunov wrote: > so, what's the problem ? psql diplo < ltree.sql ok, I can add ltree via superuser, but I must grant access for user diplo to every function... it is possible to do that easier? ---(end of broadcast)--- TIP 7: don't forget to

Re: [GENERAL] create user with database and contrib

2005-04-09 Thread Oleg Bartunov
On Sat, 9 Apr 2005, Michal Hlavac wrote: hello, is there some simple way, how to do this??? I need to create user 'diplo' with no database create and no add users privileges... createuser -A -D -P -E -U root diplo after that I create database 'diplo'; I need to import ltree into database 'diplo' wi