From: Pascal Tufenkji <ptufenkji@usj.edu.lb>
To: pgsql-sql@postgresql.org
Subject: Postgres roles
Date: Fri, 8 Feb 2008 15:02:38 +0200
Message-ID: <200802081250.m18CoZOl023674@Citrus.usj.edu.lb> (raw)
In-Reply-To: <00a401c86a43$f88de120$3102a8c0@dream>
Hi,
I'd like to ask you a question about users, groups and roles.
In older versions of Postgres we had users and groups as two separate
entities
Our IT department at work is called "sti", that's why:
- I had a user "sti" (the username of our IT manager)
- I had a group "sti" (the group containing all the users of our
department: user1, user2.)
When we upgraded to PostgreSQL 8.2.4, came up the concept of roles; users
and groups became one entity
So now I have in my database, only one role, called "sti"
My questions are:
1. how do I identify the users assigned to this role :
(in the older version)
SELECT grolist from pg_group where groname = 'sti';
2. how do I differ granting permissions on a table to the user sti from
the whole members of the group sti
(in the older version)
GRANT SELECT ON table TO group sti;
GRANT SELECT,INSERT,UPDATE,DELETE ON table TO sti;
I'd appreciate any help regarding this issue
Pascal Tufenkji
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ptufenkji@usj.edu.lb
Subject: Re: Postgres roles
In-Reply-To: <200802081250.m18CoZOl023674@Citrus.usj.edu.lb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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