From: Potluri Srikanth <spotluri@ismartpanache.com>
To: pgsql-admin@postgresql.org
Subject: Access Priviledges among multiple users (roles).
Date: Sat, 10 May 2008 10:49:43 -0500
Message-ID: <16826.1210434583@ismartpanache.com> (raw)
Hi ,
I am screwed up in permissions related issue !!!!!!!!
Senario:
==========
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,
Srikanth k Potluri
+63 9177444783(philippines)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: spotluri@ismartpanache.com
Subject: Re: Access Priviledges among multiple users (roles).
In-Reply-To: <16826.1210434583@ismartpanache.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox