Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id C9C062E003D
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Sat, 10 May 2008 12:49:47 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 98163-09
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Sat, 10 May 2008 12:49:44 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from app03.sm.onr.chicago.hostway (fw.mfg.onr.siteprotect.com
	[64.26.60.152])
	by developer.postgresql.org (Postfix) with ESMTP id E635A2E0030
	for <pgsql-admin@postgresql.org>; Sat, 10 May 2008 12:49:44 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by app03.sm.onr.chicago.hostway (Postfix) with ESMTP id 9FA0673C2CF
	for <pgsql-admin@postgresql.org>; Sat, 10 May 2008 10:49:43 -0500 (CDT)
MIME-Version: 1.0
X-Mailer: AtMail PHP 5.2
Message-ID: <16826.1210434583@ismartpanache.com>
To: <pgsql-admin@postgresql.org>
Reply-To: spotluri@ismartpanache.com
Content-Type: multipart/alternative;
	boundary="=_14b9d6e32b8038a20bb80d3099b89d36"
X-Origin: 121.97.28.3
Date: Sat, 10 May 2008 10:49:43 -0500
Subject: Access Priviledges  among multiple users (roles).
From: Potluri Srikanth <spotluri@ismartpanache.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.744 tagged_above=0 required=5 tests=AWL=0.743,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200805/78
X-Sequence-Number: 29162

--=_14b9d6e32b8038a20bb80d3099b89d36
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"

=20
 Hi ,
 I am screwed up in permissions related issue !!!!!!!!
 Senario:
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 User1 : gpadmin (DBA user)
 user2: BIUSER ( reporting user)-------------this is not a OS user,
rather a DB login ROLE.
 all table deployed in gpadmin user, having parent table and lots of
child tables.
 example:
 1) SMS (parent table)
 2) SMS_child_1
     SMS_child_2
 .........
 SMS_child_n
 Child tables( actually partitioned tables ; one child table for each
day) inherit from parent tables.
 now, there is another Reporting user : "BIUSER".
 This user need access to all tables of gpadmin user.
 how do i grant "select" priviledges on all tables in gpadmin user to
biuser in a single command, so that  current and future child tables
in gpadmin tables also becomes accessible to biuser.
 can anyone guide me the right method to do this ??
 i done want to issue grant command for each table !
 Regards,=20
 Srikanth k Potluri=20
 +63 9177444783(philippines)=20

--=_14b9d6e32b8038a20bb80d3099b89d36
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="utf-8"

<HTML>
<br>
Hi ,<br>
<br>
I am screwed up in permissions related issue !!!!!!!!<br>
<br>
Senario:<br>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>
User1 : gpadmin (DBA user)<br>
user2: BIUSER ( reporting user)-------------this is not a OS user, rather a=
 DB login ROLE.<br>
<br>
all table deployed in gpadmin user, having parent table and lots of child t=
ables.<br>
<br>
example:<br>
<br>
1) SMS (parent table)<br>
2) SMS_child_1<br>
&nbsp;&nbsp;&nbsp; SMS_child_2<br>
=2E........<br>
SMS_child_n<br>
<br>
Child tables( actually partitioned tables ; one child table for each day) i=
nherit from parent tables.<br>
<br>
now, there is another Reporting user : "BIUSER".<br>
This user need access to all tables of gpadmin user.<br>
<br>
how do i grant "select" priviledges on all tables in gpadmin user to biuser=
 in a single command, so that&nbsp; current and future child tables in gpad=
min tables also becomes accessible to biuser.<br>
<br>
can anyone guide me the right method to do this ??<br>
<br>
i done want to issue grant command for each table !<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Regards,
<br>
Srikanth k Potluri
<br>
+63 9177444783(philippines) <BR></HTML>
--=_14b9d6e32b8038a20bb80d3099b89d36--