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
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;
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
Thank you, it helps!!!