I am screwed up in permissions related issue !!!!!!!!
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
1) SMS (parent table)
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 !
Srikanth k Potluri
pgsql-admin by date
|Next:||From: Potluri Srikanth||Date: 2008-05-11 14:29:01|
|Subject: Require security ACCESS matrix in prostgresql !!|
|Previous:||From: postgresql.20.j_random_hacker||Date: 2008-05-10 10:44:39|
|Subject: Proposal for restoring a dump into a database with a different owner|