Send Multiple Grants tDBRow (Oracle)

[RVeitch_84]

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.

[Anonymous]

Hello,

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

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

[RVeitch_84]

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?

[RVeitch_84 · Accepted solution]

I figured it out:

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

Works!