Re: How to revoke a password
От | Joshua D. Drake |
---|---|
Тема | Re: How to revoke a password |
Дата | |
Msg-id | 42CF20A6.8010901@commandprompt.com обсуждение исходный текст |
Ответ на | Re: How to revoke a password ("Bailey, Larry" <lbailey@firstam.com>) |
Список | pgsql-performance |
Bailey, Larry wrote: > Thanks but it is still prompting for a password. > Does your pg_hba.conf require a password? Sincerely, Joshua D. Drake > > Larry Bailey > Sr. Oracle DBA > First American Real Estate Solution > (714) 701-3347 > lbailey@firstam.com > -----Original Message----- > From: Joshua D. Drake [mailto:jd@commandprompt.com] > Sent: Friday, July 08, 2005 5:10 PM > To: Bailey, Larry > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] How to revoke a password > > Bailey, Larry wrote: > >>I created a user with a password. That newly created user now have >>tables and indexes. I want to ALTER that user to exclude the password. >>How is this accomplished without dropping and recreating the users? > > > Never tried to go backwards before but: > > alter user foo with encrypted password ''; > > But as I look at pg_shadow there is still a hash... > > You could do: > > update pg_shadow set passwd = '' where usename = 'foo'; > > Sincerely, > > Joshua D. Drake > > > >>Larry Bailey >>Sr. Oracle DBA >>First American Real Estate Solution >>(714) 701-3347 >>lbailey@firstam.com >>********************************************************************** >>This message contains confidential information intended only for the >>use of the addressee(s) named above and may contain information that >>is legally privileged. If you are not the addressee, or the person >>responsible for delivering it to the addressee, you are hereby >>notified that reading, disseminating, distributing or copying this >>message is strictly prohibited. If you have received this message by >>mistake, please immediately notify us by replying to the message and >>delete the original message immediately thereafter. >> >>Thank you. FADLD Tag >>********************************************************************** >> >> >>---------------------------(end of >>broadcast)--------------------------- >>TIP 6: explain analyze is your friend > > > > -- > Your PostgreSQL solutions provider, Command Prompt, Inc. > 24x7 support - 1.800.492.2240, programming, and consulting Home of > PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit > http://www.commandprompt.com / http://www.postgresql.org > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Your PostgreSQL solutions provider, Command Prompt, Inc. 24x7 support - 1.800.492.2240, programming, and consulting Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit http://www.commandprompt.com / http://www.postgresql.org
В списке pgsql-performance по дате отправления: