-
Thayumanavar S authored
This worklog addresses the following functional requirements: * Provide a global command-line server startup option --disabled-storage-engines which accepts comma delimited storage engine names. DDL's which end-up creating new table or tablespace on these engines will be disallowed. Specifically, 'CREATE [TEMPORARY] TABLE', 'ALTER TABLE ... ENGINE' and 'CREATE/ALTER TABLESPACE' using one of above engine. * The SQL statements 'CREATE [TEMPORARY] TABLE', 'ALTER TABLE ... ENGINE' and 'CREATE/ALTER TABLESPACE' shall fail with the error "Storage engine 'storage engine name' is disabled (Table creation is disallowed.)" for the storage engines specified by disabled-storage-engine option. This option shall be noop and will have no effect when the server is either started with --bootstrap or --skip-grant-tables options. * This option does not affect any other DDL statements except for, 'CREATE [TEMPORARY] TABLE', 'ALTER TABLE ... ENGINE' and 'CREATE/ALTER TABLESPACE' * This option shall be noop and will have no effect when the server is either started with --bootstrap or --initialize or --initialize-insecure or --skip-grant-tables. The bootstrap and related options are used by sys admin to initialize system tables to prepare the server to operate normally and --skip-grant-tables is meant to provide full control with no authorization required.
Thayumanavar S authoredThis worklog addresses the following functional requirements: * Provide a global command-line server startup option --disabled-storage-engines which accepts comma delimited storage engine names. DDL's which end-up creating new table or tablespace on these engines will be disallowed. Specifically, 'CREATE [TEMPORARY] TABLE', 'ALTER TABLE ... ENGINE' and 'CREATE/ALTER TABLESPACE' using one of above engine. * The SQL statements 'CREATE [TEMPORARY] TABLE', 'ALTER TABLE ... ENGINE' and 'CREATE/ALTER TABLESPACE' shall fail with the error "Storage engine 'storage engine name' is disabled (Table creation is disallowed.)" for the storage engines specified by disabled-storage-engine option. This option shall be noop and will have no effect when the server is either started with --bootstrap or --skip-grant-tables options. * This option does not affect any other DDL statements except for, 'CREATE [TEMPORARY] TABLE', 'ALTER TABLE ... ENGINE' and 'CREATE/ALTER TABLESPACE' * This option shall be noop and will have no effect when the server is either started with --bootstrap or --initialize or --initialize-insecure or --skip-grant-tables. The bootstrap and related options are used by sys admin to initialize system tables to prepare the server to operate normally and --skip-grant-tables is meant to provide full control with no authorization required.
Loading