Search Postgresql Archives

Re: A question about user atributes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Le ven. 22 nov. 2019 à 13:51, stan <stanb@xxxxxxxxx> a écrit :
I am trting to do something, and it ias not working as I think it should.

Consider:

onnected to a database called stan as stan

/dt reports

List of relations
Schema |           Name           | Type  | Owner
 --------+--------------------------+-------+-------
 ica    | biz_constants            | table | stan
 ica    | bom_item                 | table | stan
 ica    | costing_unit             | table | stan
 ica    | customer                 | table | stan
 ica    | employee                 | table | stan

 Connect as user postgres to database stan and execute:

 grant all ON ALL TABLES IN SCHEMA ica to harec ;

 Connect to database stan as user harec

 stan=> \dt
 Did not find any relations.
 stan=> \c
 psql (12.1 (Debian 12.1-1.pgdg100+1), server 11.6 (Debian
 11.6-1.pgdg100+1))
 You are now connected to database "stan" as user "harec".
 stan=>

 What am I doing wrong?


Might be a wrong search_path or maybe your harec user doesn't have USAGE right on the ica schema.


--
Guillaume.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux