Thread: Information schema permissions
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? -- John Fabiani
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
On Wednesday 06 February 2008 03:37:22 pm Tom Lane wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org Thanks. Actually it would benefit my app. -- John Fabiani