Thread: I'd Like To See Permissions Granted

I'd Like To See Permissions Granted

From
"Marubayashi, Roy (Mission Systems)"
Date:
I'm just getting started using PostgreSQL and I was successfully able to create a table.  I'd like to be able to look
atwhat pemissions I've granted and see in the documentation that there is a view called usage_privileges but when I
attemptto look at this table (i.e., select * from usage_privileges) I get, 'ERROR:  relation "usage_privileges" does
notexist'.  What do I need to do in order to look at the contents of this view? 
Roy


Re: I'd Like To See Permissions Granted

From
Bruno Wolff III
Date:
On Tue, Mar 22, 2005 at 16:06:59 -0800,
  "Marubayashi, Roy (Mission Systems)" <Roy.Marubayashi@ngc.com> wrote:
> I'm just getting started using PostgreSQL and I was successfully able to create a table.  I'd like to be able to look
atwhat pemissions I've granted and see in the documentation that there is a view called usage_privileges but when I
attemptto look at this table (i.e., select * from usage_privileges) I get, 'ERROR:  relation "usage_privileges" does
notexist'.  What do I need to do in order to look at the contents of this view? 

The information_schema schema probably isn't in your search path. You
can refer to the table by qualifying its name with the schema or
changing your search path.