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

Re: I'd Like To See Permissions Granted

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Marubayashi, Roy (Mission Systems)" <Roy(dot)Marubayashi(at)ngc(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: I'd Like To See Permissions Granted
Date: 2005-03-27 15:54:31
Message-ID: 20050327155431.GD9280@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Mar 22, 2005 at 16:06:59 -0800,
  "Marubayashi, Roy (Mission Systems)" <Roy(dot)Marubayashi(at)ngc(dot)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 at what pemissions I've granted and see in the documentation that there is a view called usage_privileges but when I attempt to look at this table (i.e., select * from usage_privileges) I get, 'ERROR:  relation "usage_privileges" does not exist'.  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.

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2005-03-27 16:06:03
Subject: Re: Time Conversion
Previous:From: Christopher Kings-LynneDate: 2005-03-27 05:24:34
Subject: Re: [pgsql-advocacy] Function which gives back the nearest neighbours

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