Skip to content
  • Thayumanavar S's avatar
    4c9cba4a
    WL#8594 - PROVIDE AN OPTION TO REJECT USER TABLE CREATION UNDER SPECIFIED STORAGE ENGINES. · 4c9cba4a
    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.
    4c9cba4a
    WL#8594 - PROVIDE AN OPTION TO REJECT USER TABLE CREATION UNDER SPECIFIED STORAGE ENGINES.
    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.
Loading