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(at)Yahoo(dot)com #