Hi,
I have been looking at the new sqlcl 22.3.1 Wondering if anyone else has come across this or I am doing something stupid.
When issuing lb update command fails with insufficient privileges, debug option indicates schema name is in the sql statement when the default should be false for including qualified schema name.
08:49:05 16:12:54 SQL> lb update -changelog-file controller.xml -debug true
Parameters
---------------------------------------------
basecommand=lb debug=true changelog-file=controller.xml log=false secure-parsing=true output-default-schema=false command=update
---------------------------------------------
End Parameters
--Starting Liquibase at 08:49:16 (version 4.15.0 #0 built at 2022-08-19 14:45+0000)
-- Loaded 2 change(s)
Running Changeset: controller.xml::1666774106323-1::xxxx (generated)
liquibase.exception.MigrationFailedException: Migration failed for changeset controller.xml::1666774106323-1::xxxx (generated):
Reason: liquibase.exception.DatabaseException: ORA-01031: insufficient privileges
[Failed SQL: (1031) CREATE TABLE TEST.T1 (ID NUMBER, ITEM_NO NUMBER(6, 0), ITEM_DESC VARCHAR2(100 CHAR)) TABLESPACE USERS]
Migration failed for changeset controller.xml::1666774106323-1::xxxx (generated):
Reason: liquibase.exception.DatabaseException: ORA-01031: insufficient privileges
[Failed SQL: (1031) CREATE TABLE TEST.T1 (ID NUMBER, ITEM_NO NUMBER(6, 0), ITEM_DESC VARCHAR2(100 CHAR)) TABLESPACE USERS]
ORA-01031: insufficient privileges
08:49:19 16:12:54 SQL> sho user
USER is "TEST2"
08:49:36 16:12:54 SQL>
When the sql above is run without schema name, table creates ok:
08:51:00 16:12:54 SQL> CREATE TABLE T1 (ID NUMBER, ITEM_NO NUMBER(6, 0), ITEM_DESC VARCHAR2(100 CHAR)) TABLESPACE USERS;
Table T1 created.
Elapsed: 00:00:00.030
08:51:13 16:12:54 SQL> sho user
USER is "TEST2"
I am running sqlcl on Windows
Thanks