--=_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 ( re****ting 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 Re****ting 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 ( re****ting 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>
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 Re****ting 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 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--
|
