AW: [HACKERS] Re: [GENERAL] users in Postgresql

> > CREATE USER sql command updates the file, but an UPDATE on pg_shadow
> > does not.
> 
> How about INSERT INTO pg_shadow? Or how do you judge the 
> following excerpt
> from the createuser script:
> 
> QUERY="insert into pg_shadow \
>         (usename, usesysid, usecreatedb, usetrace, usesuper, 
> usecatupd) \
>        values \
>          ('$NEWUSER', $SYSID, '$CANCREATE', 'f', '$CANADDUSER','f')"
> 
> Fortunately (perhaps), I am getting rid of this as we're 
> speaking. The one
> feature the createuser script has over the CREATE USER "SQL" 
> command is
> that you can pick your system ID. Ignoring the question whether or not
> this has any real purpose, it seems this is almost like 
> rolling dice since

The sysid is essential for one of the authentication methods available in
PostgreSQL
(was it ident, I forgot) where the unix system password was used.

Andreas