From: | "Anthony E(dot) Greene" <agreene(at)pobox(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: User attributes |
Date: | 2000-07-07 18:32:34 |
Message-ID: | 3.0.5.32.20000707203234.007efa70@fmol.5sigcmd.army.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
At 13:07 2000-07-07 -0500, James Hall wrote:
>I am using PostgreSQL ver 6.5 on Redhat 6.1 and have 2 users that cannot
>perform the same functions as other users in the database. I am looking
>for a tool that will let me compare the records/attributes of 2 existing
>users (so I can see what the differences are and change the 2 new users
>to match the existing ones).
>
>I have read about ALTER USER, but that assumes you already know what you
>want to alter.Any suggestions on how to compare 2 users will be greatly
>appreciated.
Why not just look at the users' attributes:
psql template1
select * from pg_user where usename='user1' or usename='user2';
You may also have to look at pg_hba.conf.
Tony
--
Anthony E. Greene <agreene(at)pobox(dot)com>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Linux: The choice of a GNU Generation.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Lawrence | 2000-07-07 18:53:36 | Installing DBD |
Previous Message | James Hall | 2000-07-07 18:07:08 | User attributes |