On 10 October 2011 10:30, AI Rumman <rummandba@xxxxxxxxx> wrote: > I have an application which query on the pg_shadow view. But the user that I > was provided by my hosting server does have permission to do that. > I checked that only superuser can query in pg_shadow view. But hosting > service provider will not give me superuser permission. > Is there any other alternative way that I may follow? > Please suggest me. According to the documentation at http://www.postgresql.org/docs/8.3/static/view-pg-shadow.html you should be using pg_user instead of pg_shadow (which has been deprecated BTW). That may not solve your issue with the database hosting provider. If I would be hosting a database server for multiple customers, I would block access to even that view - the accounts of other database users (other customers) are simply none of your business. Your best bet would be to find some other way to do whatever you're using pg_shadow for. Something that will only involve users of your own database(s). -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
