diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2000-01-14 22:11:38 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2000-01-14 22:11:38 +0000 |
| commit | 4ceb2d0cb619bba2ecbf5d72a10c8fa7ba321366 (patch) | |
| tree | fedda3351400f98ed990320516f0eed80d6c1b73 /src/bin/scripts/createuser | |
| parent | 2af360ed1c5036b8d488cdb6dc94f96608375769 (diff) | |
* User management commands no longer user pg_exec_query_dest -> more robust
* Let unprivileged users change their own passwords.
* The password is now an Sconst in the parser, which better reflects its text datatype and also
forces users to quote them.
* If your password is NULL you won't be written to the password file, meaning you can't connect
until you have a password set up (if you use password authentication).
* When you drop a user that owns a database you get an error. The database is not gone.
Diffstat (limited to 'src/bin/scripts/createuser')
| -rw-r--r-- | src/bin/scripts/createuser | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/scripts/createuser b/src/bin/scripts/createuser index dd184c9a4e8..8849994b6e9 100644 --- a/src/bin/scripts/createuser +++ b/src/bin/scripts/createuser @@ -8,7 +8,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createuser,v 1.5 2000/01/12 19:36:36 petere Exp $ +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/createuser,v 1.6 2000/01/14 22:11:36 petere Exp $ # # Note - this should NOT be setuid. # @@ -193,7 +193,7 @@ QUERY="CREATE USER \"$NewUser\"" SUBQUERY= [ "$SysID" ] && SUBQUERY="$SUBQUERY SYSID $SysID" -[ "$Password" ] && SUBQUERY="$SUBQUERY PASSWORD \"$Password\"" +[ "$Password" ] && SUBQUERY="$SUBQUERY PASSWORD '$Password'" [ "$SUBQUERY" ] && QUERY="$QUERY WITH $SUBQUERY" [ "$CanCreateDb" = t ] && QUERY="$QUERY CREATEDB" |