From rexmabry@yahoo.com Tue Jul  8 16:58:52 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B932E6509C7
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 13:58:52 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 62048-03-8 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 13:58:45 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web35906.mail.mud.yahoo.com (web35906.mail.mud.yahoo.com
	[66.163.179.190])
	by postgresql.org (Postfix) with SMTP id A2B066509EE
	for <pgsql-admin@postgresql.org>; Tue,  8 Jul 2008 13:44:43 -0300 (ADT)
Received: (qmail 50843 invoked by uid 60001); 8 Jul 2008 16:44:33 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=Jot/bIzPvYTHjnmWr902Dq7WdE17tI8ObUqFHOtQSCButjN9uc987R5bA8KGEUH3nGDJZw1xm4V3dqlgg2bJnTQ8eKPr0wACZ6I+QBmRGBp77Lztg4xZf+1CVfBQBPpodbIYVHqzdmpsU8MsjEarauChG0RR+v2y09hdIIgxeFw=;
Received: from [199.200.10.52] by web35906.mail.mud.yahoo.com via HTTP;
	Tue, 08 Jul 2008 09:44:32 PDT
X-Mailer: YahooMailWebService/0.7.199
Date: Tue, 8 Jul 2008 09:44:32 -0700 (PDT)
From: Rex Mabry <rexmabry@yahoo.com>
Reply-To: rexmabry@yahoo.com
Subject: dropping a user in 8.2.6
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2100811511-1215535472=:50750"
Message-ID: <956278.50750.qm@web35906.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/89
X-Sequence-Number: 29699

--0-2100811511-1215535472=:50750
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I am using version 8.2.6
=A0
I created a role and granted all on table "instrument"=A0in=A0the database.=
=A0 But, when I tried to drop the role, I get the following error:
=A0
mydb=3D# drop role system_dba;
ERROR:=A0 role "user1" cannot be dropped because some objects depend on it
DETAIL:=A0 access to table mydb_admin.instrument

Is there a way to drop a role with some sort of "cascade" option?=0A=0A=0A =
     
--0-2100811511-1215535472=:50750
Content-Type: text/html; charset=us-ascii

<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'><P>I am using version 8.2.6</P>
<P>&nbsp;</P>
<P>I created a role and granted all on table "instrument"&nbsp;in&nbsp;the database.&nbsp; But, when I tried to drop the role, I get the following error:</P>
<P>&nbsp;</P>
<P>mydb=# drop role system_dba;<BR>ERROR:&nbsp; role "user1" cannot be dropped because some objects depend on it<BR>DETAIL:&nbsp; access to table mydb_admin.instrument<BR><BR>Is there a way to drop a role with some sort of "cascade" option?</P></td></tr></table><br>

      
--0-2100811511-1215535472=:50750--



From ineyman@perceptron.com Tue Jul  8 17:20:32 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C557D65034D
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 14:20:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 85574-03-3 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Tue,  8 Jul 2008 14:20:25 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from EXCHANGE.perceptron.com (exchange.perceptron.com
 [68.22.13.203])
	by postgresql.org (Postfix) with ESMTP id E1461650802
	for <pgsql-admin@postgresql.org>; Tue,  8 Jul 2008 14:16:22 -0300 (ADT)
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C8E11E.5540074B"
Subject: Re: dropping a user in 8.2.6
Date: Tue, 8 Jul 2008 13:16:16 -0400
Message-ID: 
 <F4C27E77F7A33E4CA98C19A9DC6722A2032D88CC@EXCHANGE.corp.perceptron.com>
In-Reply-To: <956278.50750.qm@web35906.mail.mud.yahoo.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [ADMIN] dropping a user in 8.2.6
Thread-Index: AcjhHN/f5yhubf/MS7uzy7yAz3GIvwAAU9Xg
References: <956278.50750.qm@web35906.mail.mud.yahoo.com>
From: "Igor Neyman" <ineyman@perceptron.com>
To: <rexmabry@yahoo.com>,
	<pgsql-admin@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200807/92
X-Sequence-Number: 29702

This is a multi-part message in MIME format.

------_=_NextPart_001_01C8E11E.5540074B
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

First do:
=20
DROP OWNED BY user1;
then:
drop role user1;
=20
Igor

________________________________

From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] dropping a user in 8.2.6


I am using version 8.2.6

=20

I created a role and granted all on table "instrument" in the database.
But, when I tried to drop the role, I get the following error:

=20

mydb=3D# drop role system_dba;
ERROR:  role "user1" cannot be dropped because some objects depend on it
DETAIL:  access to table mydb_admin.instrument

Is there a way to drop a role with some sort of "cascade" option?



------_=_NextPart_001_01C8E11E.5540074B
Content-Type: text/html;
	charset="us-ascii"
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=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16674" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D761131517-08072008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>First do:</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D761131517-08072008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D761131517-08072008><PRE =
class=3DSYNOPSIS>DROP OWNED BY user1;</PRE><PRE =
class=3DSYNOPSIS>then:</PRE><PRE class=3DSYNOPSIS>drop role =
user1;</PRE><PRE class=3DSYNOPSIS>&nbsp;</PRE><PRE =
class=3DSYNOPSIS>Igor</PRE></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
pgsql-admin-owner@postgresql.org=20
[mailto:pgsql-admin-owner@postgresql.org] <B>On Behalf Of </B>Rex=20
Mabry<BR><B>Sent:</B> Tuesday, July 08, 2008 12:45 PM<BR><B>To:</B>=20
pgsql-admin@postgresql.org<BR><B>Subject:</B> [ADMIN] dropping a user in =

8.2.6<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE cellSpacing=3D0 cellPadding=3D0 border=3D0>
  <TBODY>
  <TR>
    <TD vAlign=3Dtop>
      <P>I am using version 8.2.6</P>
      <P>&nbsp;</P>
      <P>I created a role and granted all on table =
"instrument"&nbsp;in&nbsp;the=20
      database.&nbsp; But, when I tried to drop the role, I get the =
following=20
      error:</P>
      <P>&nbsp;</P>
      <P>mydb=3D# drop role system_dba;<BR>ERROR:&nbsp; role "user1" =
cannot be=20
      dropped because some objects depend on it<BR>DETAIL:&nbsp; access =
to table=20
      mydb_admin.instrument<BR><BR>Is there a way to drop a role with =
some sort=20
      of "cascade" =
option?</P></TD></TR></TBODY></TABLE><BR></BODY></HTML>

------_=_NextPart_001_01C8E11E.5540074B--