On Mon, Feb 14, 2005 at 11:59:33AM -0700, James Moe wrote: > > When logged in as sma_user, it is denied access to the schema: > ERROR: permission denied for schema sma_apps See "Schemas and Privileges" in the documentation, as well as the documentation for GRANT: http://www.postgresql.org/docs/8.0/static/ddl-schemas.html#DDL-SCHEMAS-PRIV http://www.postgresql.org/docs/8.0/static/sql-grant.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend