On Wed, Nov 13, 2024, 5:00 PM Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote:
On Wed, Nov 13, 2024, 4:42 PM Achilleas Mantzios - cloud <a.mantzios@xxxxxxxxxxxxxxxxxxxx> wrote:
Exactly! In the later versions, security gets more and more refined and
strengthened. So ppl should think about moving away from "public" , and
start implementing finer grained schemes of security, as you suggest. +
\dp shows prettier than having 1000+ users listed.I wanted to just communicate the limits.a lot of postgresql architecture can leverage the resources and scale, but not all.i had 100s of 1000s of tables on my setup where i worked last.if i did \dt it would freeze all the time. i had to exit the pdwl session, check the source code of how the partition was named and then look for what I wanted.if things are pretty with psql or not should not be a criteria for how many objects you want to have.i would expect clear exceptions so one knows what the real problem is.the error I got did not in anyway communicate the role limits for col size limits.
so roles are not the problem.
but if you grant them individually select on the same table for ex. then the limits are breached based of size of the col not number of permissions.