Thread: User attributes

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.

TIA-
Jim

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@pobox.com>
 PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
 Linux: The choice of a GNU Generation.