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

Re: Limiting user access to a view only

From: jseymour(at)LinxNet(dot)com (Jim Seymour)
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Limiting user access to a view only
Date: 2004-05-05 15:56:25
Message-ID: 20040505155625.DC0D84310@jimsun.LinxNet.com (view raw or flat)
Thread:
Lists: 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


pgsql-admin by date

Next:From: Robert TreatDate: 2004-05-05 16:06:38
Subject: Re: Tool to compare db schemas?
Previous:From: Tom LaneDate: 2004-05-05 15:40:49
Subject: Re: initdb: FATAL: conversion between LATIN2 and UNICODE

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