Skip site navigation (1) Skip section navigation (2)

which database to login to to create global users?

From: pres <pgn(dot)lists(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: which database to login to to create global users?
Date: 2006-01-03 20:01:05
Message-ID: c465caf0601031201j2687eac3k5ee319c3e38873f5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
hello,

i've been a filemaker pro user for quite awhile, and have decided to take
the plunge with postgresql.

i just installed the latest release version, v8.1.1, and am slowly making my
way through documentation and tutorials.

i can launch postgres successfully, creating databases & users, reading &
writing data, etc.

it seems clear to me that if i want to create a user with access rights for
a particular database, then i do so by logging in to that particular
database, and creating ROLES, etc. that makes sense.

i'm confused about one issue -- what database should i login to if i wish to
create 'global' users? is it "template1"? "template0" seems to be generaly
inaccessible.

any advice or pointers to the right documentation would be very helpful!

thank you.

pres

Responses

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2006-01-03 20:10:55
Subject: Re: which database to login to to create global users?
Previous:From: Jaime CasanovaDate: 2006-01-03 17:33:35
Subject: Re: dropping an unused sequence?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group