Re: pg_user

ivan wrote:

> hi
> 
> can we change initdb when view pg_user is createing to :
> 
> CREATE VIEW pg_user AS \
>     SELECT \
>         usename, \
>         usesysid, \
>         usecreatedb, \
>         usesuper, \
>         usecatupd, \
>         '********'::text as passwd, \
>         valuntil, \
>         useconfig \
>     FROM pg_shadow WHERE usename = SESSION_USER;

No, at least not without a complete proposal how to retain the current 
behaviour of pg_tables, pg_views, psql's \d and other places that rely 
on pg_user being able to display all users.

It's the same thing with your /etc/passwd. chmod o-rwx /etc/passwd will 
hide the usernames but break many utilities. If you don't want someone 
to know all the logins, don't give him one.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #