Re: [ADMIN] createuser --password

2002-07-09 Thread Bhuvan A
Hi, I am not sure about the command line option, but the password for any user can be set using ALTER USER sql command. ALTER USER my_user ENCRYPTED PASSWORD 'my_pass'; also refer the documentation for details. regards, bhuvaneswaran. On 8 Jul 2002, Stephane Schildknecht wrote: > Hi, > >

Re: [ADMIN] createuser --password

2002-07-09 Thread Bruce Momjian
Felipe Nascimento wrote: > Could you explain primary and secondary passwords? > How can I create primary passwords? Primary passwords are stored in pg_shadow. We will not even support secondary passwords in 7.3 so don't worry about them. It was an old idea to allow /etc/passwd to function in Po

Re: [ADMIN] createuser --password

2002-07-09 Thread Felipe Nascimento
Title: RE: [ADMIN] createuser --password Could you explain primary and secondary passwords? How can I create primary passwords? Is a lack of security using only this secondary passwords? Tks Felipe -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: segunda

Re: [ADMIN] createuser --password

2002-07-09 Thread Bruce Momjian
oking for is: pg_passwd > > Felipe > > -Original Message- > From: Stephane Schildknecht [mailto:[EMAIL PROTECTED]] > Sent: segunda-feira, 8 de julho de 2002 06:07 > To: Postgresql-Admin; PostgreSQL-General > Subject: [ADMIN] createuser --password > > > Hi, &

Re: [ADMIN] createuser --password

2002-07-08 Thread Felipe Nascimento
Title: RE: [ADMIN] createuser --password take a look at. http://archives.postgresql.org/pgsql-admin/2001-09/msg00095.php the utility you are looking for is: pg_passwd Felipe -Original Message- From: Stephane Schildknecht [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 8 de julho

Re: [ADMIN] createuser --password

2002-07-08 Thread Artur Pietruk
On Mon, Jul 08, 2002 at 11:06:39AM +0200, Stephane Schildknecht wrote: > Hi, Hello ;-). > Is there a way to give the password of the user to be created on the > command line ? From command line you can try to do "ALTER USER", using "-c" switch of psql, eg like this: psql

[ADMIN] createuser --password

2002-07-08 Thread Stephane Schildknecht
Hi, Is there a way to give the password of the user to be created on the command line ? S@S -- _Stéphane SCHILDKNECHT___ | AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE | | Tel : 01.58.17.03.20 Fax : 01.58.17.03.21 | | mailto:[E