Re: which database to login to to create global users?

From: pres <pgn(dot)lists(at)gmail(dot)com>
To: Jaime Casanova <systemguards(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:14:47
Message-ID: c465caf0601031214j2efd61b2w9a60ec7fd70214e1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hello jaime,

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...

that's a little surprising, but definitely good to know!

so, if i understand you correctly, it does not matter which database i'm
logged into when i create a role?

where (what database/table), then, are theses assignments stored?

i've clearly misunderstood how these work, i think.

thanks,

pres

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-01-03 20:57:20 Re: which database to login to to create global users?
Previous Message Jaime Casanova 2006-01-03 20:10:55 Re: which database to login to to create global users?