Skip to Content
0
Former Member
Apr 23, 2007 at 01:07 AM

GRANT statements in EXEC SQL/ENDEXEC

56 Views

Hello, All!!

Can someone please advise if this is possible in ABAP? Sample code is:

exec sql.

GRANT SELECT ON :tabname TO 'DB_ROLE'

endexec.

I am getting a ORA-00903 error, the trace file is showing "GRANT SELECT ON :A0 TO 'OWB_BI_READONLY';"

Please advise ASAP; points guaranteed for helpful answers.

Best Regards,

Reenal