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:jimoe@xxxxxxxxxxxxxx] Sent: Mon 2/14/2005 10:59 AM To: pgsql-general@xxxxxxxxxxxxxx Cc: Subject: 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 '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----- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq !DSPAM:4210f76918377043564807! ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
