Liquibase script for grant command

Hello Experts, I am new to liquibase and hence please bear with me, what would be a sample liquibase script for below sql GRANT EXECUTE ON TEST_SCHEMA.SYS_ETL_PARAM TO TESTUSER;

Thanks,
Rajneesh

It depends on which file format that you want to use. Here is a sql example:

–liquibase formatted sql
–changeset author:grant_execute
GRANT EXECUTE ON TEST_SCHEMA.SYS_ETL_PARAM TO TESTUSER;
–rollback REVOKE EXECUTE ON TEST_SCHEMA.SYS_ETL_PARAM FROM TESTUSER;

1 Like

Hi @rajneesh4u

Have a look at the SQL tag support of liquibase, which helps to execute any SQL statement you want. Here is the link : SQL tag for liquibase

Hope this helps!
Please let us know if you face any issues with it.

Cheers!

Rakhi Agrawal

1 Like

Thank you, it helps!!!