2012/8/26 Matvey Teplov <matvey.teplov@xxxxxxxxx>
-- Hi,
Sorry to bother with the stupid question guys - I'm new to the Postgres.
I'm having issue allowing user to access the database - the user is
not allowed to access the data. I do the following:
1) grant all on database testdb table mytable to trinity;
By the command above you're granting privileges on the database
object itself, i.e. connect, create schemas, creating the temprorary
tables.
object itself, i.e. connect, create schemas, creating the temprorary
tables.
postgres=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype |
Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
testdb | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres
:
postgres=CTc/postgres
:
trinity=CTc/postgres
(4 rows)
But when I login (psql -d testdb -U trinity) as trinity and check it,
it doesn't work.
testdb=> select * from mytable;
ERROR: permission denied for relation mytable
testdb=> \dp
Access privileges
Schema | Name | Type | Access privileges | Column access privileges
--------+---------+-------+-------------------+--------------------------
public | mytable | table | |
(1 row)
There is also entry in the log:
2012-08-26 13:06:01 CEST testdb trinity ERROR: permission denied for
relation mytable
2012-08-26 13:06:01 CEST testdb trinity STATEMENT: select * from mytable;
Can someone explain what do I do wrong? Thank you in advance!
You need to grant on the another database object (table):
GRANT SELECT ON mytable TO trinity.
Please, see
http://www.postgresql.org/docs/9.2/static/sql-grant.html
GRANT SELECT ON mytable TO trinity.
Please, see
http://www.postgresql.org/docs/9.2/static/sql-grant.html
// Dmitriy.
