John R Pierce wrote: > that is correct. DATABASE privileges relate to connecting to the > database, permissions to create objects and so forth.
To be precise, there are 3 privileges: - create temporary tables - connect to the database - create schemata To be allowed to create a table, you need the create privilege on the containing schema. To be allowed to select from a table, you also need the usage privilege on the schema containing the object. You have all privileges on an object you own. I guess that should clarify the behaviour in the original question. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
