Thread: createuser --password
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:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when |
| ideas flow freely." Adam Smith |
|_________________________________________________________|
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 -c "ALTER USER test WITH PASSWORD 'test';" template1
Best regards,
--
--- Artur Pietruk, arturp@plukwa.net
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:sschildknecht@aurora-linux.com]
Sent: segunda-feira, 8 de julho de 2002 06:07
To: Postgresql-Admin; PostgreSQL-General
Subject: [ADMIN] createuser --password
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:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when |
| ideas flow freely." Adam Smith |
|_________________________________________________________|
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Uh, not really. pg_passwd is for managing secondary passwords. --------------------------------------------------------------------------- Felipe Nascimento wrote: > 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:sschildknecht@aurora-linux.com] > Sent: segunda-feira, 8 de julho de 2002 06:07 > To: Postgresql-Admin; PostgreSQL-General > Subject: [ADMIN] createuser --password > > > 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:sschildknecht@aurora-linux.com - ICQ : 142504394 | > | "Free Markets have taught that innovation is best when | > | ideas flow freely." Adam Smith | > |_________________________________________________________| > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
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, > > Is there a way to give the password of the user to be created on the > command line ? > > S@S >
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:pgman@candle.pha.pa.us]
Sent: segunda-feira, 8 de julho de 2002 15:45
To: Felipe Nascimento
Cc: 'Stephane Schildknecht'; Postgresql-Admin; PostgreSQL-General
Subject: Re: [ADMIN] createuser --password
Uh, not really. pg_passwd is for managing secondary passwords.
---------------------------------------------------------------------------
Felipe Nascimento wrote:
> 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:sschildknecht@aurora-linux.com]
> Sent: segunda-feira, 8 de julho de 2002 06:07
> To: Postgresql-Admin; PostgreSQL-General
> Subject: [ADMIN] createuser --password
>
>
> 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:sschildknecht@aurora-linux.com - ICQ : 142504394 |
> | "Free Markets have taught that innovation is best when |
> | ideas flow freely." Adam Smith |
> |_________________________________________________________|
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
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 PostgreSQL, but the idea wasn't very valuable. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026