MySQL 8.3.0
Source Code Documentation
Sql_cmd_show_grants Class Reference

Represents SHOW GRANTS statement. More...

#include <sql_show.h>

Inheritance diagram for Sql_cmd_show_grants:
[legend]

Public Member Functions

 Sql_cmd_show_grants (const LEX_USER *for_user_arg, const List< LEX_USER > *using_users_arg)
 
bool check_privileges (THD *thd) override
 Perform an authorization check for a prepared SELECT statement. More...
 
bool execute_inner (THD *thd) override
 The inner parts of query optimization and execution. More...
 
- Public Member Functions inherited from Sql_cmd_show
 Sql_cmd_show (enum_sql_command sql_command)
 
enum_sql_command sql_command_code () const override
 Return the command code for this statement. More...
 
virtual bool check_parameters (THD *)
 
bool precheck (THD *thd) override
 Generally, the SHOW commands do not distinguish precheck and regular check. More...
 
- Public Member Functions inherited from Sql_cmd_select
 Sql_cmd_select (Query_result *result_arg)
 
bool is_data_change_stmt () const override
 
bool accept (THD *thd, Select_lex_visitor *visitor) override
 
const MYSQL_LEX_CSTRINGeligible_secondary_storage_engine (THD *thd) const override
 Is this statement of a type and on a form that makes it eligible for execution in a secondary storage engine? More...
 
- Public Member Functions inherited from Sql_cmd_dml
bool prepare (THD *thd) override
 Command-specific resolving (doesn't include LEX::prepare()) More...
 
enum enum_sql_cmd_type sql_cmd_type () const override
 
bool is_single_table_plan () const override
 
Query_resultquery_result () const
 
void set_query_result (Query_result *result)
 Set query result object for this query statement. More...
 
void set_lazy_result ()
 Signal that root result object needs preparing in next execution. More...
 
- Public Member Functions inherited from Sql_cmd
bool needs_explicit_preparation () const
 
bool is_regular () const
 
bool is_prepared () const
 
virtual void cleanup (THD *)
 Command-specific reinitialization before execution of prepared statement. More...
 
void set_owner (Prepared_statement *stmt)
 Set the owning prepared statement. More...
 
Prepared_statementowner () const
 Get the owning prepared statement. More...
 
void set_as_part_of_sp ()
 Mark statement as part of procedure. More...
 
bool is_part_of_sp () const
 
virtual bool is_bulk_load () const
 
void disable_secondary_storage_engine ()
 Disable use of secondary storage engines in this statement. More...
 
void enable_secondary_storage_engine ()
 
bool secondary_storage_engine_disabled () const
 Has use of secondary storage engines been disabled for this statement? More...
 
void use_secondary_storage_engine (const handlerton *hton)
 Mark the current statement as using a secondary storage engine. More...
 
bool using_secondary_storage_engine () const
 Is this statement using a secondary storage engine? More...
 
const handlertonsecondary_engine () const
 Get the handlerton of the secondary engine that is used for executing this statement, or nullptr if a secondary engine is not used. More...
 
void set_optional_transform_prepared (bool value)
 
bool is_optional_transform_prepared ()
 

Private Attributes

const LEX_USERfor_user
 
const List< LEX_USER > * using_users
 

Additional Inherited Members

- Protected Member Functions inherited from Sql_cmd_show_noplan
 Sql_cmd_show_noplan (enum_sql_command sql_command)
 
bool execute (THD *thd) override
 Execute a DML statement. More...
 
- Protected Member Functions inherited from Sql_cmd_select
bool may_use_cursor () const override
 
bool prepare_inner (THD *thd) override
 Prepare a SELECT statement. More...
 
- Protected Member Functions inherited from Sql_cmd_dml
 Sql_cmd_dml ()
 
bool is_empty_query () const
 
void set_empty_query ()
 Set statement as returning no data. More...
 
bool check_all_table_privileges (THD *thd)
 Read and check privileges for all tables in a DML statement. More...
 
virtual bool restore_cmd_properties (THD *thd)
 Restore command properties before execution. More...
 
virtual bool save_cmd_properties (THD *thd)
 Save command properties, such as prepared query details and table props. More...
 
const MYSQL_LEX_CSTRINGget_eligible_secondary_engine (THD *thd) const
 Helper function that checks if the command is eligible for secondary engine and if that's true returns the name of that eligible secondary storage engine. More...
 
- Protected Member Functions inherited from Sql_cmd
 Sql_cmd ()
 
virtual ~Sql_cmd ()
 
void set_prepared ()
 Set this statement as prepared. More...
 
- Protected Attributes inherited from Sql_cmd_show
enum_sql_command m_sql_command
 
- Protected Attributes inherited from Sql_cmd_dml
LEXlex
 Pointer to LEX for this statement. More...
 
Query_resultresult
 Pointer to object for handling of the result. More...
 
bool m_empty_query
 True if query will produce no rows. More...
 
bool m_lazy_result
 True: prepare query result on next execution. More...
 

Detailed Description

Represents SHOW GRANTS statement.

Constructor & Destructor Documentation

◆ Sql_cmd_show_grants()

Sql_cmd_show_grants::Sql_cmd_show_grants ( const LEX_USER for_user_arg,
const List< LEX_USER > *  using_users_arg 
)
inline

Member Function Documentation

◆ check_privileges()

bool Sql_cmd_show_grants::check_privileges ( THD thd)
overridevirtual

Perform an authorization check for a prepared SELECT statement.

Reimplemented from Sql_cmd_show.

◆ execute_inner()

bool Sql_cmd_show_grants::execute_inner ( THD thd)
overridevirtual

The inner parts of query optimization and execution.

Execute a DML statement.

Single-table DML operations needs to reimplement this.

Parameters
thdThread handler
Returns
false on success, true on error

This is the default implementation for a DML statement and uses a nested-loop join processor per outer-most query block. The implementation is split in two: One for query expressions containing a single query block and one for query expressions containing multiple query blocks combined with UNION.

Reimplemented from Sql_cmd_dml.

Member Data Documentation

◆ for_user

const LEX_USER* Sql_cmd_show_grants::for_user
private

◆ using_users

const List<LEX_USER>* Sql_cmd_show_grants::using_users
private

The documentation for this class was generated from the following files: