Operation Audit¶
security_enable_options¶
Parameter description: Specifies whether grant_to_public, grant_with_grant_option, and foreign_table_options can be used in security mode. (This parameter is supported only by clusters of version 8.2.0 or later.)
Type: SIGHUP
Value range: a string
on indicates that grant to public can be used in security mode.
on indicates that with grant option can be used in security mode.
foreign_table_options allows users to perform operations on foreign tables in security mode without explicitly granting the useft permission to users.
Default value: empty
Note
In a newly installed cluster, this parameter is left blank by default, indicating that none of grant_to_public, grant_with_grant_option, and foreign_table_options can be used in security mode.
In upgrade scenarios, the default value of this parameter is forward compatible. If the default values of enable_grant_public and enable_grant_option are ON before the upgrade, the default value of security_enable_options is grant_to_public, grant_with_grant_option after the upgrade.