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 #