Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6E92E9FB50D for ; Wed, 8 Aug 2007 18:37:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 03139-02 for ; Wed, 8 Aug 2007 18:35:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.247]) by postgresql.org (Postfix) with ESMTP id CBC6E9FB8F5 for ; Wed, 8 Aug 2007 18:35:53 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so49309ana for ; Wed, 08 Aug 2007 14:35:52 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:mime-version:content-type; b=Tr+WOlqaQhDIiSIleKkyff3RiuQS6IuBqYLc3EciPWCV0dTSAgME6cgUTT0ya6JQDTYEnnZBhu9i/xbh7YpMz72zww8h46e/bHZXtHNDEQtUiVgRoRKUgoOfb0o/uDAV8LIGQOkrf8jL0MkQhkpoPNvVBNpF/YfyljqNooAU1wg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:mime-version:content-type; b=ZkVCTj73PT33EruRXu4D2D7G1sxhmnCYf2KK/7L4iuWY8SxSrr222D0bzDuV2+aL3p4pWMRqEXChj8RYxw5+ZdcSMnnWJ0mDBpnXMUzYLgHrLiQCV/DemGkFJn9vvyLugVOrvjvdybYPySmQQN0RgRP/0uf2qrx2cCiIwKwyfsc= Received: by 10.100.173.19 with SMTP id v19mr578896ane.1186608951267; Wed, 08 Aug 2007 14:35:51 -0700 (PDT) Received: by 10.100.191.10 with HTTP; Wed, 8 Aug 2007 14:35:51 -0700 (PDT) Message-ID: <9b3f75f0708081435p23494a95gd2ac55adf3db02b3@mail.gmail.com> Date: Wed, 8 Aug 2007 18:35:51 -0300 From: "Anderson Alves de Albuquerque " To: pgsql-admin@postgresql.org Subject: Permission ALTER PASSWORD Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7485_31078184.1186608951089" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/88 X-Sequence-Number: 26419 ------=_Part_7485_31078184.1186608951089 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I have problem with permission, I need to use a user no SUPERUSER. I use commands: CREATE ROLE $USER LOGIN; ALTER user $USER noCREATEDB NOCREATEROLE noCREATEUSER NOINHERIT; ALTER USER $USER with password 'XX'; REVOKE create on SCHEMA public from public; revoke all on schema PUBLIC FROM $USER; With these commands MY user $USER don't have permission to create table and another thing. But I need that $USER can't have permission to change your password with: psql -d $BD -h $HOST -U $USER # ALTER $USER maluco with password 'YYY'; After user $USER execute this ALTER, it get change PASSWORD. Could I block command ALTER password to user $USER? ------=_Part_7485_31078184.1186608951089 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
 
 I have problem with permission, I need to use a user no SUPERUSER.
 
 I use commands:
CREATE ROLE $USER LOGIN;
ALTER user $USER noCREATEDB  NOCREATEROLE noCREATEUSER NOINHERIT; 
ALTER USER $USER with password 'XX';
REVOKE create on SCHEMA public from public;
revoke all on schema PUBLIC FROM $USER;
 
 With these commands MY user $USER don't have permission to create table and another thing. But I need that $USER can't have permission to change your password with:
psql -d $BD -h $HOST -U $USER
# ALTER $USER maluco with password  'YYY';
 
 After user $USER execute this ALTER, it get change PASSWORD. Could I block command ALTER password to user $USER? 
 
------=_Part_7485_31078184.1186608951089--