Re: A question about user atributes
От | Guillaume Lelarge |
---|---|
Тема | Re: A question about user atributes |
Дата | |
Msg-id | CAECtzeWkKY7frOm8J6NujKRMDF7g_vRweGW_dWE+oiGCKkeErw@mail.gmail.com обсуждение исходный текст |
Ответ на | A question about user atributes (stan <stanb@panix.com>) |
Список | pgsql-general |
Hi,
Le ven. 22 nov. 2019 à 13:51, stan <stanb@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.
В списке pgsql-general по дате отправления: