| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Thom Brown <thom(at)linux(dot)com> |
| Cc: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Curious case of the unstoppable user |
| Date: | 2011-03-29 21:29:21 |
| Message-ID: | 835B2085-1D2E-4307-A8DC-64BBADA554F7@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mar 30, 2011, at 12:14 AM, Thom Brown wrote:
> postgres=# CREATE ROLE testrole;
> CREATE ROLE
> postgres=# REVOKE ALL ON DATABASE testdb FROM testrole CASCADE;
> REVOKE
> postgres=# \c testdb testrole
> FATAL: role "testrole" is not permitted to log in
> Previous connection kept
You have created role and trying to login as role. Create user and then try.
USER=ROLE+Login Privilege.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vibhor Kumar | 2011-03-29 21:31:29 | Re: OSX Postgres PL/Perl Problem with Finance::Quote/Options |
| Previous Message | Guillaume Lelarge | 2011-03-29 21:27:11 | Re: Curious case of the unstoppable user |