User granted all access to schema, but can't see tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This is v12 from RHEL repos.

As user postgres, I run:

sides=# grant all on SCHEMA strans TO stransuser;
GRANT

sides=# ALTER DEFAULT PRIVILEGES IN SCHEMA strans GRANT all on tables to stransuser;
ALTER DEFAULT PRIVILEGES

sides=# GRANT USAGE ON SCHEMA strans TO stransuser;
GRANT

But user stransuser still can’t access tables

sides=> \d
             List of relations
Schema |    Name    |   Type   |  Owner
--------+------------+----------+----------
strans | foo        | table    | postgres
strans | foo_id_seq | sequence | postgres
(2 rows)

sides=> select * from strans.foo;
ERROR:  permission denied for table foo

sides=> \z strans.foo
                                Access privileges
Schema | Name | Type  |     Access privileges     | Column privileges | Policies
--------+------+-------+---------------------------+-------------------+----------
strans | foo  | table | postgres=arwdDxt/postgres+|                   |
       |      |       | READWRITE=arwdD/postgres +|                   |
       |      |       | READONLY=r/postgres |                   |
(1 row)

What am I missing?

--
Angular momentum makes the world go 'round.





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux