Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'

From: jwieck(at)debis(dot)com (Jan Wieck)
To: pgsql-hackers(at)postgreSQL(dot)org (PostgreSQL HACKERS)
Subject: Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'
Date: 1998-02-24 13:23:22
Message-ID: m0y7KKR-000BFRC@orion.SAPserv.Hamburg.dsh.de (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
> On Tue, 24 Feb 1998, Jan Wieck wrote:
> 
> >         CREATE TABLE xpg_usr (
> >             usename         name,
> >             usesysid        int4,
> >             usecreatedb     bool,
> >             usetrace        bool,
> >             usesuper        bool,
> >             usecatupd       bool,
> >             passwd          text,
> >             valuntil        abstime);
> > 
> >         UPDATE pg_class SET relname = 'pg_usr'
> >             WHERE relname = 'xpg_usr';
> > 
> >         CREATE RULE _RETpg_usr AS ON SELECT TO pg_usr
> >             DO INSTEAD
> >             SELECT usename, usesysid, usecreatedb,
> >                    usetrace, usesuper, usecatupd,
> >                    '********'::text as passwd, valuntil
> >                    FROM pg_user;
> > 
> >         REVOKE ALL ON pg_user FROM public;
> 
> 	Okay, just so that I don't mess things up in the translation...do
> you want to send me an appropriate patch for this?
> 
> > >     But as it was done  in  most  UN*X's,  could  we  rename  the
> > >     pg_user  containing  the  password  into  pg_shadow  and then
> > >     create a view pg_user that just stars out the password field?
> > >     This  way  no  existing  application  code (not even the JDBC
> > >     etc.) needs any  changes,  except  for  the  createuser  etc.
> > >     tools that always get installed with the new release.
> > 
> >     Still vote for this. And as soon as  we  finally  choose  one
> >     name  for  the public pg_user view we must fix createuser.sh,
> >     createdb.sh and so on to make  their  checks  on  the  public
> >     accessible view so they still print the proper error messages
> >     instead of
> 
> 	No arguments here...can you include this as part of your patch
> too?

	Will do so.

Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #


In response to

Responses

pgsql-hackers by date

Next:From: Thomas G. LockhartDate: 1998-02-24 13:29:27
Subject: Re: [HACKERS] Re: [BUGS] agregate function sum error
Previous:From: The Hermit HackerDate: 1998-02-24 13:14:11
Subject: Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group