pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Limiting user access to a view only
4+ messages / 4 participants
[nested] [flat]

* Limiting user access to a view only
@ 2004-05-04 19:12 Richard Colman <colman@uci.edu>
  2004-05-05 16:27 ` Re: Limiting user access to a view only Gaetano Mendola <mendola@bigfoot.com>
  2004-05-05 17:10 ` Re: Limiting user access to a view only Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 2 replies; 4+ messages in thread

From: Richard Colman @ 2004-05-04 19:12 UTC (permalink / raw)
  To: pgsql-admin

I am a novice in this area.

How would I set up a new user on PostgreSQL so that the new user is limited
to reading a particular view, and can do nothing else.

Help greatly appreciated.

Richard Colman
Institute for Genomics and Bioinformatics
949-824-1816, 701-5330
colman@uci.edu




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Limiting user access to a view only
  2004-05-04 19:12 Limiting user access to a view only Richard Colman <colman@uci.edu>
@ 2004-05-05 16:27 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Gaetano Mendola @ 2004-05-05 16:27 UTC (permalink / raw)
  To: Richard Colman <colman@uci.edu>

Richard Colman wrote:

 > I am a novice in this area.
 >
 > How would I set up a new user on PostgreSQL so that the new user is 
limited
 > to reading a particular view, and can do nothing else.

Hi,
first of all create the user as no a super user, after use the
GRANT  command
  ( http://www.postgresql.org/docs/7.4/interactive/sql-grant.html )


in your case:

GRANT SELECT ON <view_name> TO <user_name>



Regards
Gaetano Mendola








^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Limiting user access to a view only
  2004-05-04 19:12 Limiting user access to a view only Richard Colman <colman@uci.edu>
@ 2004-05-05 17:10 ` Peter Eisentraut <peter_e@gmx.net>
  1 sibling, 0 replies; 4+ messages in thread

From: Peter Eisentraut @ 2004-05-05 17:10 UTC (permalink / raw)
  To: Richard Colman <colman@uci.edu>; pgsql-admin

Richard Colman wrote:
> How would I set up a new user on PostgreSQL so that the new user is
> limited to reading a particular view, and can do nothing else.

A new user normally can't do anything.  Just grant the privileges on the 
view to him.  You may also want to revoke all permissions on databases 
and schemas, some of which are set to allow everything by default.  The 
GRANT manual page contains more information and pointers.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Limiting user access to a view only
@ 2004-05-05 15:56 Jim Seymour <jseymour@LinxNet.com>
  0 siblings, 0 replies; 4+ messages in thread

From: jseymour@LinxNet.com @ 2004-05-05 15:56 UTC (permalink / raw)
  To: pgsql-admin

> 
> I am a novice in this area.
> 
> How would I set up a new user on PostgreSQL so that the new user is limited
> to reading a particular view, and can do nothing else.
> 
> Help greatly appreciated.

You will find these handy, no doubt...

http://www.postgresql.org/docs/7.4/static/tutorial.html
http://www.postgresql.org/docs/7.4/static/sql-createuser.html
http://www.postgresql.org/docs/7.4/static/sql-grant.html

Jim




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-05-05 17:10 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-04 19:12 Limiting user access to a view only Richard Colman <colman@uci.edu>
2004-05-05 16:27 ` Gaetano Mendola <mendola@bigfoot.com>
2004-05-05 17:10 ` Peter Eisentraut <peter_e@gmx.net>
2004-05-05 15:56 Re: Limiting user access to a view only Jim Seymour <jseymour@LinxNet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox