Обсуждение: password

Поиск
Список
Период
Сортировка

password

От
"Vladimir V. Zolotych"
Дата:
Hello all,

Very simple question if you please

How can I set password on existing database ?

Thanks! 

-- 
Vladimir Zolotych                         gsmith@eurocom.od.ua
 

Re: password

От
"Oliver Elphick"
Дата:
"Vladimir V. Zolotych" wrote:
  >How can I set password on existing database ?

template1=# \help alter user
Command:     ALTER USER
Description: Modifies user account information
Syntax:
ALTER USER username
    [ WITH PASSWORD 'password' ]
    [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ VALID UNTIL 'abstime' ]

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "All that the Father giveth me shall come to me; and
      him that cometh to me I will in no wise cast out."
                                      John 6:37