pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPermissions to a schema
3+ messages / 3 participants
[nested] [flat]
* Permissions to a schema
@ 2009-02-03 16:33 Campbell, Lance <lance@illinois.edu>
2009-02-03 17:23 ` Re: Permissions to a schema Carol Walter <walterc@indiana.edu>
2009-02-04 01:28 ` Re: Permissions to a schema Daniel J. Summers <daniel@djs-consulting.com>
0 siblings, 2 replies; 3+ messages in thread
From: Campbell, Lance @ 2009-02-03 16:33 UTC (permalink / raw)
To: pgsql-admin
How do I do the following:
1) Create a user group.
2) Assign access to select, delete, insert, and update to any table
found in the following X number of schemas.
3) Assign the newly created user group permissions to a new user.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu <http://webservices.uiuc.edu/;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Permissions to a schema
2009-02-03 16:33 Permissions to a schema Campbell, Lance <lance@illinois.edu>
@ 2009-02-03 17:23 ` Carol Walter <walterc@indiana.edu>
1 sibling, 0 replies; 3+ messages in thread
From: Carol Walter @ 2009-02-03 17:23 UTC (permalink / raw)
To: Campbell, Lance <lance@illinois.edu>; +Cc: pgsql-admin
I believe that this is dependent on what version of postgres you are
using. What you want to do is create a role. You do this by issuing
the CREATE ROLE command...
CREATE ROLE select_role;
GRANT SELECT on MyTable to select_role;
GRANT select_role TO MyUser;
Carol
On Feb 3, 2009, at 11:33 AM, Campbell, Lance wrote:
> How do I do the following:
>
> 1) Create a user group.
> 2) Assign access to select, delete, insert, and update to any
> table found in the following X number of schemas.
> 3) Assign the newly created user group permissions to a new user.
>
> Thanks,
>
> Lance Campbell
> Project Manager/Software Architect
> Web Services at Public Affairs
> University of Illinois
> 217.333.0382
> http://webservices.uiuc.edu
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Permissions to a schema
2009-02-03 16:33 Permissions to a schema Campbell, Lance <lance@illinois.edu>
@ 2009-02-04 01:28 ` Daniel J. Summers <daniel@djs-consulting.com>
1 sibling, 0 replies; 3+ messages in thread
From: Daniel J. Summers @ 2009-02-04 01:28 UTC (permalink / raw)
To: pgsql-admin
Campbell, Lance wrote:
>
> How do I do the following:
>
> 1) Create a user group.
>
> 2) Assign access to select, delete, insert, and update to any table
> found in the following X number of schemas.
>
> 3) Assign the newly created user group permissions to a new user.
>
When you're going through the tables, don't forget the sequences for any
"serial" fields you may have. You'll get errors trying to insert, even
though you've granted INSERT on that table. As best I can tell (haven't
seen this in a document anywhere), your role needs SELECT and UPDATE on
those sequences.
--
Daniel J. Summers
*Owner, DJS Consulting* Support <http://support.djs-consulting.com/; •
Tech Blog <http://www.djs-consulting.com/linux/blog;
daniel@djs-consulting.com <mailto:daniel@djs-consulting.com> •
http://www.djs-consulting.com <http://www.djs-consulting.com/;
GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M--
V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-02-04 01:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-03 16:33 Permissions to a schema Campbell, Lance <lance@illinois.edu>
2009-02-03 17:23 ` Carol Walter <walterc@indiana.edu>
2009-02-04 01:28 ` Daniel J. Summers <daniel@djs-consulting.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox