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.