Re: Roles - Mailing list pgsql-novice

From Bruce Hyatt
Subject Re: Roles
Date
Msg-id 336319.14089.qm@web34401.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Roles  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Roles
List pgsql-novice
--- On Fri, 11/21/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> There's no builtin concept of an "admin"
> role.  There is such a thing as
> superuser, but that's a property of a role not a
> specific role (ie, you
> can have more than one superuser role if you want).  See
> "Database roles
> and privileges" chapter in the manual.  The CREATE
> ROLE reference page
> has some details too.  Be sure to consult the manual
> version
> corresponding to the PG version you are using, as the
> features in this
> area have changed over time.
>
>             regards, tom lane

Thanks for the response Tom, especially at this day and hour.

I will revisit these pages but I would like to draw your attention to this page:

http://www.postgresql.org/docs/8.3/interactive/sql-createuser.html

Are the options not essentially existing roles?

Sincerely,
Bruce




pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Roles
Next
From: Tim Bowden
Date:
Subject: Re: Roles