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: (view raw or whole thread)
Lists: pgsql-novice

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

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

thank you.



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-2015 The PostgreSQL Global Development Group