pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLimiting 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>
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-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
* Re: Limiting user access to a view only
@ 2004-05-05 16:27 Gaetano Mendola <mendola@bigfoot.com>
parent: Richard Colman <colman@uci.edu>
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-05 17:10 Peter Eisentraut <peter_e@gmx.net>
parent: Richard Colman <colman@uci.edu>
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
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