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
On 20 jul 2008, at 16.09, Daniel J. Summers wrote:
I just tried "GRANT CONNECT", and the problem still exists.
If you try to login to the database using psql, instead of
phpPgAdmin, what does it tell you? Error messages?
Sincerely,
Niklas Johansson
--
Sent via pgsql-admin mailing l
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 s
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
I'm running PostgreSQL 8.3 on Kubuntu 8.04. My goal is to create a
database with one user as its owner, and another as a user with
non-administrative access to this database that I'll use as the runtime
user for a web application. As the user "postgres", I executed the
following commands in p
