Re: which database to login to to create global users? - Mailing list pgsql-novice

From pres
Subject Re: which database to login to to create global users?
Date
Msg-id c465caf0601031214j2efd61b2w9a60ec7fd70214e1@mail.gmail.com
Whole thread Raw
In response to Re: which database to login to to create global users?  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: which database to login to to create global users?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-novice by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: which database to login to to create global users?
Next
From: Tom Lane
Date:
Subject: Re: which database to login to to create global users?