Thread: problem with databases

problem with databases

From
"Martin A. Marques"
Date:
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.

TIA!

--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart�n Marqu�s            email:     martin@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Re: problem with databases

From
"Oliver Elphick"
Date:
"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