A new topic, 'Change Log Parameters for Custom SQL Changesets', has been made
on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=432.new#new
The text of the topic is shown below:
Does it work to use Change Log Parameters in a Custom SQL Changeset?
Here is a link to Change Log Parameters:
http://www.liquibase.org/manual/changelog_parameters
We need to do a bunch of change owner, revoke, and grant statements for
different roles in the database. We want our clients to be able to define the
names of their roles and want our Custom SQL Changeset to hopefully look like
the following:
Code:
<changeSet author='jsmith' id='1' runAlways='true'>
<sql splitStatements="false">
ALTER SCHEMA a_schema_name OWNER TO ${user.admin};
REVOKE ALL ON SCHEMA a_schema_name FROM public;
GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA a_schema_name TO
${user.user};
ALTER TABLE a_schema_name.a_table OWNER TO ${user.admin};
REVOKE ALL ON TABLE a_schema_name.a_table FROM public;
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE a_schema_name.a_table TO
${user.user};
GRANT SELECT ON TABLE a_schema_name.a_table TO ${user.read_only};
</sql>
</changeSet>
Will the above Change Log Parameter substitution work?
Thank you for your time.
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
