Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4AEE39FA103 for ; Sat, 9 Dec 2006 20:13:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 55147-03 for ; Sat, 9 Dec 2006 20:13:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90515.mail.mud.yahoo.com (web90515.mail.mud.yahoo.com [216.252.100.182]) by postgresql.org (Postfix) with SMTP id 50EF19F9EED for ; Sat, 9 Dec 2006 20:13:32 -0400 (AST) Received: (qmail 94528 invoked by uid 60001); 10 Dec 2006 00:13:30 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=K3cXERwrkRaQvtmJlNYVBjJqSImKsT3gR6zKn+Cmcb2AxQaX0jAdjmck/zcRzB73d4c044IbCmtlsX9cfXU2cMFW6bR8j7D5uQKwfffuZ+qdmrqNT/7WWWQBYDc22dC80q8cK6a0g7zViv20EgWLT0nz/rG9AvmezjMLBvCJ+VA=; X-YMail-OSG: KZAQQNUVM1mBbVcvBUbOg5lleMMHVEhifwLNRHlbp8Nqj1plS2N0RR5M1LeOh1F08g-- Received: from [70.19.76.226] by web90515.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 16:13:30 PST Date: Sat, 9 Dec 2006 16:13:30 -0800 (PST) From: Philippe Salama Subject: \c bpsimple rick To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-949885259-1165709610=:92978" Content-Transfer-Encoding: 8bit Message-ID: <279843.92978.qm@web90515.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.088 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/126 X-Sequence-Number: 23918 --0-949885259-1165709610=:92978 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-949885259-1165709610=:92978 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-949885259-1165709610=:92978--