Re: Roles

From: Bruce Hyatt <brucejhyatt(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Roles
Date: 2008-11-22 02:58:33
Message-ID: 336319.14089.qm@web34401.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- On Fri, 11/21/08, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

  • Re: Roles at 2008-11-22 04:37:47 from Tim Bowden

Browse pgsql-novice by date

  From Date Subject
Next Message Tim Bowden 2008-11-22 04:37:47 Re: Roles
Previous Message Tom Lane 2008-11-22 02:21:42 Re: Roles