Niklas Johansson wrote:
On 20 jul 2008, at 04.47, Daniel J. Summers wrote:
grant usage on database custom_database to user_no_2;
Now, none of these commands failed - they all came back with "CREATE
ROLE" (or the appropriate response).
Are you sure?
'GRANT USAGE ON DATABASE...' is invalid syntax. You probably want
'GRANT CONNECT ON DATABASE...'.
Ah - it had been a while since I originally set it up. I just tried
"GRANT CONNECT", and the problem still exists. Thanks for the
suggestion. :)
--
Daniel J. Summers
Owner, DJS Consulting
E-mail - [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Website - http://www.djs-consulting.com <http://www.djs-consulting.com/>
Technology Blog - http://www.djs-consulting.com/linux/blog
GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M--
V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
