Stephen Frost <sfrost@xxxxxxxxxxx> writes: > \dn+ in psql will give you the access privileges for all schemas. > I'd have to look at the "other solutions" you're referring to, but, in > general, we do not exclude the public role in any way from the access > privilege system. Possibly Greg was thinking of the information_schema views. Grants to PUBLIC do show up in those. The problem is that there's no view there that covers schema privileges, probably because the SQL standard doesn't really have any such thing as grantable schema privileges. (Or at least it didn't last I heard, I might be out of date.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
