I want to find out all the users under a specific user. postgres is a superuser of postgresql, under in postres user i made one user ABC and under this ABC user i made XYZ,MNO,IJK users. Now i want to find out all the users, which r exist under in ABC user so what is the query for it?
select relname, array_to_string(relacl,',') as acl from pg_class where array_to_string(relacl,',') ~ '/ABC[,$]'; HTH Ben K. Developer http://benix.tamu.edu
