Hi
2018-03-06 16:51 GMT+01:00 chris :
> Hi,
>
> I am trying to create a function that gets passed a statement as a string
> and then I need to change the table_name within the string by adding a
> "_cdc" to it, then execute the statement
>
> ex:
>
> string passed could be GRANT all ON authors TO
Hi,
I am trying to create a function that gets passed a statement as a
string and then I need to change the table_name within the string by
adding a "_cdc" to it, then execute the statement
ex:
string passed could be GRANT all ON authors TO bob.
then
EXECUTE GRANT all ON authors_cdc TO bob