dbTalk Databases Forums  

How Can a User Change His/Her Password?

comp.databases.postgresql comp.databases.postgresql


Discuss How Can a User Change His/Her Password? in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
R. Joseph Newton
 
Posts: n/a

Default How Can a User Change His/Her Password? - 09-27-2006 , 03:12 PM






Hi Folks,

This is my first post to this group, and of the 100 threads appearing when I
subscribed, I haven't seen any mention of the problem. Nor does any of the PG
documentation I have seen refer to it:

After the admin creates a new user, I would like to have that user change the
password. A password does not seem very secure if it is shared, even with the
admin who creates the user. What is the standard methodolgy for doing this in
PostgreSQL?

I'mabit perplexed by this,because it strikes me that user-level password secrecy
is just essential to overall system security. Fortunately, my PostgreSQL work
right now is all experimental, so there is no critical security problem -- until
I start using this RDBMS tool in a real-world seting.

My PG version is 8.1, running on XP Pro.

Thanks,

Joseph Newton


Reply With Quote
  #2  
Old   
Ch Lamprecht
 
Posts: n/a

Default Re: How Can a User Change His/Her Password? - 09-27-2006 , 03:18 PM






R. Joseph Newton wrote:
Quote:
Hi Folks,

This is my first post to this group, and of the 100 threads appearing when I
subscribed, I haven't seen any mention of the problem. Nor does any of the PG
documentation I have seen refer to it:

After the admin creates a new user, I would like to have that user change the
password. A password does not seem very secure if it is shared, even with the
admin who creates the user. What is the standard methodolgy for doing this in
PostgreSQL?

I'mabit perplexed by this,because it strikes me that user-level password secrecy
is just essential to overall system security. Fortunately, my PostgreSQL work
right now is all experimental, so there is no critical security problem -- until
I start using this RDBMS tool in a real-world seting.

My PG version is 8.1, running on XP Pro.

Thanks,

Joseph Newton

ALTER USER username WITH PASSWORD 'a_password'

Christoph Lamprecht

--

perl -e "print scalar reverse q/ed.enilno (AT) ergn (DOT) l.hc/"


Reply With Quote
  #3  
Old   
R. Joseph Newton
 
Posts: n/a

Default Re: How Can a User Change His/Her Password? - 09-27-2006 , 11:12 PM



Ch Lamprecht wrote:

Quote:
R. Joseph Newton wrote:
Hi Folks,

This is my first post to this group, and of the 100 threads appearing when I
subscribed, I haven't seen any mention of the problem. Nor does any of the PG
documentation I have seen refer to it:

After the admin creates a new user, I would like to have that user change the
password. A password does not seem very secure if it is shared, even with the
admin who creates the user. What is the standard methodolgy for doing this in
PostgreSQL?

I'mabit perplexed by this,because it strikes me that user-level password secrecy
is just essential to overall system security. Fortunately, my PostgreSQL work
right now is all experimental, so there is no critical security problem -- until
I start using this RDBMS tool in a real-world seting.

My PG version is 8.1, running on XP Pro.

Thanks,

Joseph Newton

ALTER USER username WITH PASSWORD 'a_password'

Christoph Lamprecht

--

perl -e "print scalar reverse q/ed.enilno (AT) ergn (DOT) l.hc/"
Okay, thanks. Any places where the password change command might be stored and
available for prying admin types? I did fnd one-- inthe console where the command was
made, but that might be a glitch in the Windows/postrges interaction, and seems
transient, going away when the console is closed.

Joseph





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.