\c bpsimple rick - Mailing list pgsql-admin

From Philippe Salama
Subject \c bpsimple rick
Date
Msg-id 279843.92978.qm@web90515.mail.mud.yahoo.com
Whole thread Raw
Responses Re: \c bpsimple rick
Re: \c bpsimple rick
List pgsql-admin
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.

I am confused, since clearly, I created user/role rick as someone with the power to create databases.



Access over 1 million songs - Yahoo! Music Unlimited.

pgsql-admin by date:

Previous
From: Philippe Salama
Date:
Subject: Well, I am making some progress with createdb/dropdb
Next
From: "olivier.boissard@cerene.fr"
Date:
Subject: Re: Installing postgres now. What is a good shareware admin