X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BFDB711F7DDC for ; Mon, 10 Apr 2006 10:15:44 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.122 X-Spam-Level: X-Spam-Status: No, score=0.122 required=5 tests=[AWL=0.120, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id p+te0Sf0txAP for ; Mon, 10 Apr 2006 10:13:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 714C411F7DE4 for ; Mon, 10 Apr 2006 10:11:53 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k3AD59B9002823 for ; Mon, 10 Apr 2006 18:35:10 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 83DBA332666for ; Mon, 10 Apr 2006 18:35:09 +0530 (IST) Message-ID: <022f01c65ca1$38471370$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: creating user Date: Mon, 10 Apr 2006 18:48:12 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_022C_01C65CCF.51E9CBA0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Archive-Number: 200604/87 X-Sequence-Number: 21256 This is a multi-part message in MIME format. ------=_NextPart_000_022C_01C65CCF.51E9CBA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi... I want to know more about alter user /creating users.I am facing error = if i give user with Login/Nologin..Why is it so? But it is working fine for Createdb/NoCreatedb.etc. sample=3D# ALTER user sandhya with LOGIN; ERROR: syntax error at or near "LOGIN" at character 25 LINE 1: ALTER user sandhya with LOGIN; Please explain me about this/Suggest Some Manual where in i can find = more about this.I have gone through postgres site. -Sandhya ------=_NextPart_000_022C_01C65CCF.51E9CBA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi...
 I want to know more about alter user /creating = users.I=20 am facing error if i give user with Login/Nologin..Why is it = so?
But it is working fine for=20 Createdb/NoCreatedb.etc.
 
sample=3D# ALTER user sandhya with = LOGIN;
ERROR:  syntax=20 error at or near "LOGIN" at character 25
LINE 1: ALTER user sandhya = with=20 LOGIN;
 
Please explain me about this/Suggest Some Manual = where in i=20 can find more about this.I have gone through postgres site.
 
-Sandhya
------=_NextPart_000_022C_01C65CCF.51E9CBA0--