topic Re: Send Multiple Grants tDBRow (Oracle) in Talend Studio

Send Multiple Grants tDBRow (Oracle)

RVeitch_84 — Fri, 15 Nov 2024 22:45:37 GMT

I'm trying to send multple grant via a single tDBRow , here is a sample of my query.

GRANT ALTER ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\" ;

GRANT DELETE ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\" ;

If I send one it works fine without the ; at the end?

GRANT ALTER ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\"

But I need to do 23 grants?

Any help would be appricated.

Re: Send Multiple Grants tDBRow (Oracle)

Anonymous — Mon, 11 Jul 2022 01:25:37 GMT

Hello,

I'm not sure if the below statement match your requirement?

GRANT ALL ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\" ;

Re: Send Multiple Grants tDBRow (Oracle)

RVeitch_84 — Mon, 11 Jul 2022 13:28:10 GMT

No ,as I have several users to GRANT, so I was looking to do them all in one tDBRow and I don't want to use the ALL function as I don't need all 11 GRANTS.

So I would need the following as an example:

GRANT ALTER ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\" ;

GRANT DELETE ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\" ;

GRANT INSERT ON \"SQUARE\".\""+context.table+"\" TO \"OAX_USER\" ;

Which doesn't work?

Re: Send Multiple Grants tDBRow (Oracle)

RVeitch_84 — Mon, 11 Jul 2022 15:10:06 GMT

I figured it out:

GRANT READ,INDEX,SELECT ON \"SQUARE\".\""+context.table_Locations+"\" TO \"2_USER\",\"2$OAC\"

Works!