Skip site navigation (1) Skip section navigation (2)

Re: User attributes

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: (view raw, whole thread or download thread mbox)
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

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.

 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 LawrenceDate: 2000-07-07 18:53:36
Subject: Installing DBD
Previous:From: James HallDate: 2000-07-07 18:07:08
Subject: User attributes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group