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)