Skip site navigation (1) Skip section navigation (2)

Re: psql missing feature: show permissions for functions

From: "John R Pierce" <pierce(at)hogranch(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>, "Jorge Godoy" <godoy(at)ieee(dot)org>
Subject: Re: psql missing feature: show permissions for functions
Date: 2004-09-20 22:15:25
Message-ID: 132201c49f5f$5444efd0$0200a8c0@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-bugs
> I was trying to check some permissions on functions and then I noticed
> that there's no command in psql to show that information.  I've tried
> using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5.
> 
> It would be an interesting addition to have that, as we do have the
> commands to show permissions on tables.

ah, I found it.  try...

    SELECT proacl FROM pg_proc WHERE proname='functioname';




In response to

Responses

pgsql-bugs by date

Next:From: Jorge GodoyDate: 2004-09-20 22:35:58
Subject: Re: psql missing feature: show permissions for functions
Previous:From: Conal TuohyDate: 2004-09-20 21:47:01
Subject: Re: Error starting service on Win2k

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group