From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
---|---|
To: | pres <pgn(dot)lists(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: which database to login to to create global users? |
Date: | 2006-01-03 20:10:55 |
Message-ID: | c2d9e70e0601031210u7ad5b88fi95f7ec19e84ef8a5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 1/3/06, pres <pgn(dot)lists(at)gmail(dot)com> wrote:
> 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
>
roles are always global... i don't think you can create roles that
exist just in one database...
you assign permissions to roles via the GRANT statement...
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
From | Date | Subject | |
---|---|---|---|
Next Message | pres | 2006-01-03 20:14:47 | Re: which database to login to to create global users? |
Previous Message | pres | 2006-01-03 20:01:05 | which database to login to to create global users? |