:59 AM
To: pgsql-general@postgresql.org
Cc:
Subject:[GENERAL] Privileges question
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
~ I created a schema, database, tables, users and a user group.
create user sma_user password 'x';
create group sma_user_group;
al
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
~ I created a schema, database, tables, users and a user group.
create user sma_user password 'x';
create group sma_user_group;
alter group sma_user_group add user sma_user;
create table sma_apps.ordr_dat ( ... );
grant select,delete,insert
