Re: problem with databases - Mailing list pgsql-general

From Oliver Elphick
Subject Re: problem with databases
Date
Msg-id 200004260603.e3Q639F08609@linda.lfix.co.uk
Whole thread Raw
In response to problem with databases  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
"Martin A. Marques" wrote:
  >I'm trying to get IMP to work, and I need to create 2 databases which I have
  >problems creating.
  >What I get is this:
  >
  >GRANT SELECT, INSERT, UPDATE ON active_sessions, auth_user, auth_user_md5 TO
      > nobody;
  >ERROR:  aclparse: non-existent user "nobody"
  >
  >I don't know how to add the user nobody to grant him with permission to
  >connect to the horde database.

CREATE USER nobody NOCREATEDB NOCREATEUSER

I don't think there is any easy way to give a user access to a whole
database, except by granting permission on each object separately.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Submit yourselves therefore to God. Resist the devil,
      and he will flee from you."          James 4:7



pgsql-general by date:

Previous
From: Jeffrey
Date:
Subject: Re:
Next
From: "Oliver Elphick"
Date:
Subject: Re: Having trouble getting readline functional in psql