Re: Information schema permissions

johnf <jfabiani(at)yolo(dot)com> writes:
> Assume a standard install on Linux (what ever that means). Would a normal
> user have access to information schema? I have a front end written in python
> that accesses tables and permissions are set based on roles. But I do
> nothing with respect to the information schema view. I would like my program
> to access the view. Would there be anything preventing a standard user
> from 'SELECT' access?

The information schema views are accessible to anyone, but be aware that
they show different sets of rows to different people --- you can only
see rows that are about tables that you have some access permissions
for. This might or might not confuse your app ...

regards, tom lane