A question about user atributes

stan <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.