Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Tim BowdenDate: 2008-11-22 04:37:47
Subject: Re: Roles
Previous:From: Tom LaneDate: 2008-11-22 02:21:42
Subject: Re: Roles

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group