| From: | James Moe <jimoe(at)sohnen-moe(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Privileges question |
| Date: | 2005-02-14 18:59:33 |
| Message-ID: | 4210F515.4020802@sohnen-moe.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
~ I created a schema, database, tables, users and a user group.
create user sma_user password 'xxxxx';
create group sma_user_group;
alter group sma_user_group add user sma_user;
create table sma_apps.ordr_dat ( ... );
grant select,delete,insert,update on sma_apps.ordr_dat to group
sma_user_group;
~ Access privileges for database "smadb1"
~ Schema | Name | Type | Access privileges
-
----------+----------+-------+---------------------------------------------------------------------
~ sma_apps | ordr_dat | table | {sma_admin=arwdRxt/sma_admin,"group
sma_user_group=arwd/sma_admin"}
~ When logged in as sma_user, it is denied access to the schema:
ERROR: permission denied for schema sma_apps
What am I missing? How do I provide access to a schema?
- --
jimoe at sohnen-moe dot com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (OS/2)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFCEPUUzTcr8Prq0ZMRAvU/AJ90kwdpxNYGgHdzBA7A2uPFo4FcNwCdFeGz
Q7Dte87qrtET8yoI7uZ9VD0=
=0sLa
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-02-14 19:40:28 | Re: possible bug with compound index. |
| Previous Message | Bruce Momjian | 2005-02-14 18:55:47 | Re: possible bug with compound index. |