Re: Information schema permissions

johnf <jfabiani@yolo.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