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)