From: | stan <stanb(at)panix(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | A question about user atributes |
Date: | 2019-11-22 12:50:52 |
Message-ID: | 20191122125052.GA18345@panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2019-11-22 12:58:11 | Re: A question about user atributes |
Previous Message | Marc Millas | 2019-11-22 10:35:10 | Re: Extract transactions from wals ?? |