Hi, Le ven. 22 nov. 2019 à 13:51, stan <st...@panix.com> 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.
