Pascal Tufenkji wrote:
Hi Shane,
You are exactly right.
My issue is that, I now have one role called sti - that has carried the
group members from the old version -
So what do you think my options are, so I can separate them?
I have only one option in my mind:
- Revoke the me
ry 08, 2008 3:54 PM
To: [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Postgres roles
Pascal Tufenkji wrote:
> My questions are:
>
>
>
> 1. how do I identify the users assigned to this role :
> (in the older version)
> SELECT grolist f
Pascal Tufenkji wrote:
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';
"The view pg_group exists for backwards compatibility: it emulates a
catalog that existed in PostgreSQL before
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"
