Re: [postgresql 9.2.3] schema and privileges - Mailing list pgsql-novice

From kobolds
Subject Re: [postgresql 9.2.3] schema and privileges
Date
Msg-id 1363287527916-5748489.post@n5.nabble.com
Whole thread Raw
In response to Re: [postgresql 9.2.3] schema and privileges  (Christian Hammers <ch@lathspell.de>)
Responses Re: [postgresql 9.2.3] schema and privileges
List pgsql-novice
Hi,

thanks for reply.
from what i read in postgresql doc
"By default, users cannot access any objects in schemas they do not own. To
allow that, the owner of the schema must grant the USAGE privilege on the
schema. To allow users to make use of the objects in the schema, additional
privileges might need to be granted, as appropriate for the object."

but i already did grant all privileges on schema sh1 to user1;

so why user1 still unable to  access.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-9-2-3-schema-and-privileges-tp5748331p5748489.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


pgsql-novice by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: PostgreSQL and Ubuntu (and Evergreen)
Next
From: Kevin Grittner
Date:
Subject: Re: [postgresql 9.2.3] schema and privileges