Re: A question about user atributes

Hi,

Le ven. 22 nov. 2019 à 13:51, stan <[email protected]> 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.