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
Why not just look at the users' attributes:
select * from pg_user where usename='user1' or usename='user2';
You may also have to look at pg_hba.conf.
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.
pgsql-novice by date
|Next:||From: Stephen Lawrence||Date: 2000-07-07 18:53:36|
|Subject: Installing DBD|
|Previous:||From: James Hall||Date: 2000-07-07 18:07:08|
|Subject: User attributes|