| From: | Philippe Salama <karebacnyc(at)yahoo(dot)com> |
|---|---|
| To: | PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | \c bpsimple rick |
| Date: | 2006-12-10 00:13:30 |
| Message-ID: | 279843.92978.qm@web90515.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philippe Salama | 2006-12-10 00:40:48 | Re: \c bpsimple rick |
| Previous Message | olivier.boissard@cerene.fr | 2006-12-10 00:05:21 | Re: Installing postgres now. What is a good shareware admin |