James --
I am not sure if anyone answered this yet, but you might try:
GRANT USAGE ON SCHEMA sma_apps TO sma_user;
as the same user as createdthe schema ...
HTH,
Greg Williamson
DBA
GlobeXplorer LLC
-Original Message-
From: James Moe [mailto:[EMAIL PROTECTED]
Sent: Mon 2/14/2005 10:
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
