Re: Limiting user access to a view only - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Limiting user access to a view only
Date
Msg-id 200405051910.26469.peter_e@gmx.net
Whole thread Raw
In response to Limiting user access to a view only  ("Richard Colman" <colman@uci.edu>)
List 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.



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: initdb: FATAL: conversion between LATIN2 and UNICODE
Next
From: Chris Gamache
Date:
Subject: Postmaster hogs CPU