pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Philippe Salama <karebacnyc@yahoo.com>
Cc: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Re: \c bpsimple rick
Date: Sat, 09 Dec 2006 22:37:26 -0500
Message-ID: <27890.1165721846@sss.pgh.pa.us> (raw)
In-Reply-To: <279843.92978.qm@web90515.mail.mud.yahoo.com>
References: <279843.92978.qm@web90515.mail.mud.yahoo.com>

Philippe Salama <karebacnyc@yahoo.com> writes:
> My textbook had me create a user named rick, with the power to create databases, but not the power to create new users.
> in the next exercise, I am in template1 as user neil, who has the prompt =# which means that neil has power to create databases.  I am told to \c bpsimple rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has no power to create databases.

How old is your textbook?

What the # prompt actually means is that you are a "superuser", which
means you can do anything at all within PostgreSQL (equivalent to root
on a Unix system, and I-dunno-what on Windows).  Creating databases
is a lesser privilege.  It used to be that creating users was only
allowed to a superuser, but now we have a lesser privilege that allows
non-superusers to create more (non-super) users.  In any case, if you
are superuser you can definitely do both of those things.

If the book equates the # prompt to create-database privilege then it's
flat out wrong, or at least has been for as long as I can remember.
If it equates # to create-user privilege then it's only been wrong for
the last release or two.

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <27890.1165721846@sss.pgh.pa.us>
Permalink:  ../27890.1165721846@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/27890.1165721846@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, karebacnyc@yahoo.com
  Subject: Re: \c bpsimple rick
  In-Reply-To: <27890.1165721846@sss.pgh.pa.us>
  References: <279843.92978.qm@web90515.mail.mud.yahoo.com> <27890.1165721846@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox