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

Re: the "users" group and restricting privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Tenenbaum <dandante(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: the "users" group and restricting privileges
Date: 2005-11-30 00:21:31
Message-ID: 11392.1133310091@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Dan Tenenbaum <dandante(at)gmail(dot)com> writes:
> ERROR: permission denied for schema myschema
> What do I need to do to get the correct permissions?

GRANT USAGE ON SCHEMA myschema TO whoever

Schema access is comparable to directory access in a filesystem: if you
can't look into the directory, it doesn't matter what privileges you
might have for the individual files in it.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Dan TenenbaumDate: 2005-11-30 02:36:59
Subject: Re: the "users" group and restricting privileges
Previous:From: Jim C. NasbyDate: 2005-11-30 00:13:04
Subject: Re: the "users" group and restricting privileges

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