Hi,
I am new to postgres (using for the first time) - and I am having problems creating user accounts (and granting permissions).
I have a user called 'matrix' and a database called 'matrix' - I am trying to grant all privileges to this database for the given user - ie
Quote:
matrix=# \z matrix;
Access privileges for database "matrix"
Schema | Table | Access privileges
--------+-------+-------------------
(0 rows)
matrix=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+---------- +-----------
postgres | 1 | t | t | t | ******** | |
matrix | 101 | t | f | f | ******** | [
|
Then I try and grant permissions -
Quote:
matrix=# GRANT ALL ON matrix TO matrix;
ERROR: relation "matrix" does not exist
|
I have spent a fair bit of time googling, and looking at the postgres site...but I am obviously missing something
- Any advice greatly appreciated.
Thanks,
Andrew.
