alter user problem

alter user problem

Post by Christopher Kings-Lynn » Sat, 21 Dec 2002 11:30:17



This is a multi-part message in MIME format.

------=_NextPart_000_0099_01C2A812.C9335F20
Content-Type: text/plain;
        charset="GB2312"
Content-Transfer-Encoding: 7bit

You need to go:

ALTER USER "EDU" WITH PASSWORD 'aaaa';

Since you have used an uppercase name, you will always need to double quote
it.

Chris

  -----Original Message-----


  Sent: Friday, 20 December 2002 10:01 AM

  Subject: [HACKERS] alter user problem

  Hi all

  I have install Postgresql 7.3 with user name EDU.
  then I enter the psql to change the password for EDU using "alter user EDU
with password 'aaaa''
  it returns " user EDU do not exist".
  I check the system table pg_user, and the user 'EDU' actually exists.
  But if I take the following SQL, it works
  "create user TEST'
  "Alter user TEST with password 'dddd';
  I check the pg_user again, and find the user "TEST' is replace by 'test'.
  So I have a question:
  How I change the password for the initial user "EDU", or is it  a bug for
postgresql 7.3?
  Great thanks for any message
  Josh.

------=_NextPart_000_0099_01C2A812.C9335F20
Content-Type: text/html;
        charset="GB2312"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff si=
ze=3D2>You=20
need to go:</FONT></SPAN></DIV>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff si=
ze=3D2>ALTER=20
USER "EDU" WITH PASSWORD 'aaaa';</FONT></SPAN></DIV>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff si=
ze=3D2>Since=20
you have used an uppercase name, you will always need to double quote=20
it.</FONT></SPAN></DIV>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D584392902-20122002><FONT face=3DArial color=3D#0000ff=20
size=3D2>Chris</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px soli=
d; MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT face=3DTah=
oma=20
  size=3D2>-----Original Message-----<BR><B>From:</B>=20


  </B>postgresql<BR><B>Sent:</B> Friday, 20 December 2002 10:01 AM<BR><B>To=
:</B>=20

  problem<BR><BR></FONT></DIV>
  <P>Hi all</P>
  <P>I have install Postgresql 7.3 with user name EDU.<BR>then I enter the =
psql=20
  to change the password for EDU using "alter user EDU with password=20
  'aaaa''<BR>it returns " user EDU do not exist".<BR>I check the system tab=
le=20
  pg_user, and the user 'EDU' actually exists.<BR>But if I take the followi=
ng=20
  SQL, it works<BR>"create user TEST'<BR>"Alter user TEST with password=20
  'dddd';<BR>I check the pg_user again, and find the user "TEST' is replace=
 by=20
  'test'.<BR>So I have a question:<BR>How I change the password for the ini=
tial=20
  user "EDU", or is it&nbsp; a bug for postgresql 7.3?<BR>Great thanks for =
any=20
  message<BR>Josh.</P></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0099_01C2A812.C9335F20--

 
 
 

1. alter database/user set problem

I use the PostgreSQL 7.3.1.=0D
=0D
pippo=3D# ALTER user postgres SET "Autocommit" =3D "on"\g=0D
ALTER USER=0D
pippo=3D# ALTER user postgres SET "autocommit" =3D "off"\g=0D
ALTER USER=0D
pippo=3D# select usename,useconfig from pg_shadow\g=0D
    usename    |           useconfig=0D
---------------+-------------------------------=0D
 postgres      | {Autocommit=3Don,autocommit=3Doff}=0D
=0D
Which autocommit it used from the user?=0D
=0D
Bye !!=0D
Frank Lupo (Wolf) !!=0D
=0D
    /\_ _/\=0D
    \ o o /=0D
--ooo-----ooo---

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Fare shopping con EmailConto Risparmio =E8 facile e conveniente: con un sol=
o click sconti tutti i tuoi acquisti!
Provalo adesso.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=3D839&d=3D28-1

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

2. Standard Problem?

3. alter user to change user's password returns pg_shadow: Permission

4. Virginia - Oracle Financials and HR/Payroll Functional Specialists

5. Alter table Alter column problem.

6. Variable Paramerter Update Stored Procedure.

7. ALTER TABLE/ALTER COLUMN problem with MS Access 2K

8. Transactions and Database Procedures

9. Altering indexes with users logged in

10. ALTER USER diff Oracle7 vs Oracle 8

11. Alter an Oracle user name

12. How to alter User Defined Data Types

13. ALTER USER versus GRANT/REVOKE