Gecko [ www.finalhopeacademy.com ]

Name	Size	Permission
atomic	[ DIR ]	drwxr-xr-x
aria_backup.h	1.38 KB	-rw-r--r--
authors.h	9.59 KB	-rw-r--r--
backup.h	1.21 KB	-rw-r--r--
bounded_queue.h	6.58 KB	-rw-r--r--
client_settings.h	1.89 KB	-rw-r--r--
compat56.h	2.23 KB	-rw-r--r--
config.h	14.33 KB	-rw-r--r--
contributors.h	2.92 KB	-rw-r--r--
create_options.h	4.26 KB	-rw-r--r--
custom_conf.h	1.06 KB	-rw-r--r--
datadict.h	1.61 KB	-rw-r--r--
debug_sync.h	1.71 KB	-rw-r--r--
derived_handler.h	2.32 KB	-rw-r--r--
derror.h	980 B	-rw-r--r--
des_key_file.h	1.21 KB	-rw-r--r--
discover.h	1.53 KB	-rw-r--r--
dur_prop.h	1.06 KB	-rw-r--r--
embedded_priv.h	1.47 KB	-rw-r--r--
event_data_objects.h	3.88 KB	-rw-r--r--
event_db_repository.h	3.56 KB	-rw-r--r--
event_parse_data.h	2.83 KB	-rw-r--r--
event_queue.h	3.36 KB	-rw-r--r--
event_scheduler.h	3.21 KB	-rw-r--r--
events.h	4.54 KB	-rw-r--r--
field.h	189.86 KB	-rw-r--r--
field_comp.h	1.15 KB	-rw-r--r--
filesort.h	4.7 KB	-rw-r--r--
filesort_utils.h	3.78 KB	-rw-r--r--
ft_global.h	3.04 KB	-rw-r--r--
gcalc_slicescan.h	16.87 KB	-rw-r--r--
gcalc_tools.h	11.53 KB	-rw-r--r--
group_by_handler.h	3.09 KB	-rw-r--r--
gstream.h	2.38 KB	-rw-r--r--
ha_partition.h	62.15 KB	-rw-r--r--
ha_sequence.h	5.54 KB	-rw-r--r--
handle_connections_win.h	852 B	-rw-r--r--
handler.h	178.71 KB	-rw-r--r--
hash.h	4.33 KB	-rw-r--r--
hash_filo.h	5.41 KB	-rw-r--r--
heap.h	9.23 KB	-rw-r--r--
hostname.h	5.29 KB	-rw-r--r--
ilist.h	6.84 KB	-rw-r--r--
init.h	852 B	-rw-r--r--
innodb_priv.h	1.29 KB	-rw-r--r--
item.h	248.7 KB	-rw-r--r--
item_cmpfunc.h	120.42 KB	-rw-r--r--
item_create.h	8.39 KB	-rw-r--r--
item_func.h	110.72 KB	-rw-r--r--
item_geofunc.h	28.54 KB	-rw-r--r--
item_inetfunc.h	6.56 KB	-rw-r--r--
item_jsonfunc.h	13.63 KB	-rw-r--r--
item_row.h	5.02 KB	-rw-r--r--
item_strfunc.h	58.95 KB	-rw-r--r--
item_subselect.h	52.43 KB	-rw-r--r--
item_sum.h	63.56 KB	-rw-r--r--
item_timefunc.h	53.89 KB	-rw-r--r--
item_vers.h	3.63 KB	-rw-r--r--
item_windowfunc.h	30.7 KB	-rw-r--r--
item_xmlfunc.h	3.37 KB	-rw-r--r--
key.h	2 KB	-rw-r--r--
keycaches.h	1.95 KB	-rw-r--r--
lex.h	28.37 KB	-rw-r--r--
lex_hash.h	138.65 KB	-rw-r--r--
lex_string.h	2.07 KB	-rw-r--r--
lex_symbol.h	1.29 KB	-rw-r--r--
lex_token.h	41.28 KB	-rw-r--r--
lf.h	6.31 KB	-rw-r--r--
lock.h	2.16 KB	-rw-r--r--
log.h	43.43 KB	-rw-r--r--
log_event.h	160.18 KB	-rw-r--r--
log_event_old.h	19.2 KB	-rw-r--r--
log_slow.h	1.98 KB	-rw-r--r--
maria.h	17.38 KB	-rw-r--r--
mariadb.h	1.25 KB	-rw-r--r--
mdl.h	36.08 KB	-rw-r--r--
mem_root_array.h	6.94 KB	-rw-r--r--
message.h	1.17 KB	-rw-r--r--
multi_range_read.h	22.5 KB	-rw-r--r--
my_alarm.h	2.35 KB	-rw-r--r--
my_apc.h	4.62 KB	-rw-r--r--
my_atomic.h	7.11 KB	-rw-r--r--
my_atomic_wrapper.h	2.8 KB	-rw-r--r--
my_base.h	26.27 KB	-rw-r--r--
my_bit.h	3.44 KB	-rw-r--r--
my_bitmap.h	6.07 KB	-rw-r--r--
my_check_opt.h	2.56 KB	-rw-r--r--
my_compare.h	10.93 KB	-rw-r--r--
my_context.h	6.59 KB	-rw-r--r--
my_counter.h	1.68 KB	-rw-r--r--
my_cpu.h	4.01 KB	-rw-r--r--
my_crypt.h	904 B	-rw-r--r--
my_decimal.h	13.09 KB	-rw-r--r--
my_default.h	2.47 KB	-rw-r--r--
my_handler_errors.h	4.73 KB	-rw-r--r--
my_json_writer.h	17.11 KB	-rw-r--r--
my_libwrap.h	1.16 KB	-rw-r--r--
my_md5.h	1.45 KB	-rw-r--r--
my_minidump.h	848 B	-rw-r--r--
my_nosys.h	1.4 KB	-rw-r--r--
my_rdtsc.h	7.76 KB	-rw-r--r--
my_rnd.h	1.04 KB	-rw-r--r--
my_service_manager.h	1.47 KB	-rw-r--r--
my_stacktrace.h	2.99 KB	-rw-r--r--
my_time.h	10.22 KB	-rw-r--r--
my_tree.h	3.9 KB	-rw-r--r--
my_uctype.h	67.9 KB	-rw-r--r--
my_user.h	1.1 KB	-rw-r--r--
myisam.h	16.92 KB	-rw-r--r--
myisamchk.h	4.77 KB	-rw-r--r--
myisammrg.h	4.66 KB	-rw-r--r--
myisampack.h	14.58 KB	-rw-r--r--
mysql_async.h	1.77 KB	-rw-r--r--
mysqld.h	32.14 KB	-rw-r--r--
mysqld_default_groups.h	204 B	-rw-r--r--
mysqld_suffix.h	1.17 KB	-rw-r--r--
mysys_err.h	2.81 KB	-rw-r--r--
nt_servc.h	2.94 KB	-rw-r--r--
opt_range.h	54.69 KB	-rw-r--r--
opt_subselect.h	14.16 KB	-rw-r--r--
opt_trace.h	8.11 KB	-rw-r--r--
opt_trace_context.h	3.21 KB	-rw-r--r--
parse_file.h	4.12 KB	-rw-r--r--
partition_element.h	5.09 KB	-rw-r--r--
partition_info.h	16.77 KB	-rw-r--r--
password.h	1.14 KB	-rw-r--r--
pcre.h	30.97 KB	-rw-r--r--
probes_mysql.h	973 B	-rw-r--r--
probes_mysql_dtrace.h	32.23 KB	-rw-r--r--
probes_mysql_nodtrace.h	4.89 KB	-rw-r--r--
procedure.h	5.9 KB	-rw-r--r--
protocol.h	10.95 KB	-rw-r--r--
proxy_protocol.h	548 B	-rw-r--r--
queues.h	3.46 KB	-rw-r--r--
records.h	2.93 KB	-rw-r--r--
repl_failsafe.h	1.55 KB	-rw-r--r--
replication.h	15.73 KB	-rw-r--r--
rijndael.h	1.67 KB	-rw-r--r--
rowid_filter.h	15.07 KB	-rw-r--r--
rpl_constants.h	3.28 KB	-rw-r--r--
rpl_filter.h	4.41 KB	-rw-r--r--
rpl_gtid.h	13.25 KB	-rw-r--r--
rpl_injector.h	9.41 KB	-rw-r--r--
rpl_mi.h	13.65 KB	-rw-r--r--
rpl_parallel.h	13.52 KB	-rw-r--r--
rpl_record.h	1.55 KB	-rw-r--r--
rpl_record_old.h	1.37 KB	-rw-r--r--
rpl_reporting.h	2.96 KB	-rw-r--r--
rpl_rli.h	31.89 KB	-rw-r--r--
rpl_tblmap.h	3.1 KB	-rw-r--r--
rpl_utility.h	9.32 KB	-rw-r--r--
scheduler.h	3.4 KB	-rw-r--r--
scope.h	1.76 KB	-rw-r--r--
select_handler.h	1.99 KB	-rw-r--r--
semisync.h	2.23 KB	-rw-r--r--
semisync_master.h	22.68 KB	-rw-r--r--
semisync_master_ack_receiver.h	5.73 KB	-rw-r--r--
semisync_slave.h	3.47 KB	-rw-r--r--
service_versions.h	1.91 KB	-rw-r--r--
session_tracker.h	12.81 KB	-rw-r--r--
set_var.h	15.66 KB	-rw-r--r--
slave.h	11.99 KB	-rw-r--r--
source_revision.h	67 B	-rw-r--r--
sp.h	21.69 KB	-rw-r--r--
sp_cache.h	2 KB	-rw-r--r--
sp_head.h	59.95 KB	-rw-r--r--
sp_pcontext.h	24.3 KB	-rw-r--r--
sp_rcontext.h	14 KB	-rw-r--r--
span.h	3.84 KB	-rw-r--r--
spatial.h	20.82 KB	-rw-r--r--
sql_acl.h	17.83 KB	-rw-r--r--
sql_admin.h	2.74 KB	-rw-r--r--
sql_alloc.h	1.83 KB	-rw-r--r--
sql_alter.h	11.56 KB	-rw-r--r--
sql_analyse.h	10.91 KB	-rw-r--r--
sql_analyze_stmt.h	9.64 KB	-rw-r--r--
sql_array.h	6.29 KB	-rw-r--r--
sql_audit.h	13.55 KB	-rw-r--r--
sql_base.h	24.8 KB	-rw-r--r--
sql_basic_types.h	9.23 KB	-rw-r--r--
sql_binlog.h	895 B	-rw-r--r--
sql_bitmap.h	7.95 KB	-rw-r--r--
sql_bootstrap.h	1.63 KB	-rw-r--r--
sql_cache.h	21.15 KB	-rw-r--r--
sql_callback.h	1.51 KB	-rw-r--r--
sql_class.h	236.46 KB	-rw-r--r--
sql_cmd.h	8.47 KB	-rw-r--r--
sql_connect.h	3.77 KB	-rw-r--r--
sql_const.h	10.83 KB	-rw-r--r--
sql_crypt.h	1.4 KB	-rw-r--r--
sql_cte.h	16.01 KB	-rw-r--r--
sql_cursor.h	2.26 KB	-rw-r--r--
sql_db.h	2.16 KB	-rw-r--r--
sql_debug.h	4.65 KB	-rw-r--r--
sql_delete.h	1.37 KB	-rw-r--r--
sql_derived.h	1.26 KB	-rw-r--r--
sql_digest.h	3.73 KB	-rw-r--r--
sql_digest_stream.h	1.53 KB	-rw-r--r--
sql_do.h	954 B	-rw-r--r--
sql_error.h	37.79 KB	-rw-r--r--
sql_explain.h	26.09 KB	-rw-r--r--
sql_expression_cache.h	4.23 KB	-rw-r--r--
sql_get_diagnostics.h	7.66 KB	-rw-r--r--
sql_handler.h	2.84 KB	-rw-r--r--
sql_help.h	920 B	-rw-r--r--
sql_hset.h	3.17 KB	-rw-r--r--
sql_insert.h	2.1 KB	-rw-r--r--
sql_join_cache.h	47.04 KB	-rw-r--r--
sql_lex.h	160.22 KB	-rw-r--r--
sql_lifo_buffer.h	9.26 KB	-rw-r--r--
sql_list.h	21.55 KB	-rw-r--r--
sql_load.h	1.25 KB	-rw-r--r--
sql_locale.h	2.61 KB	-rw-r--r--
sql_manager.h	960 B	-rw-r--r--
sql_mode.h	6.58 KB	-rw-r--r--
sql_parse.h	8.12 KB	-rw-r--r--
sql_partition.h	12.31 KB	-rw-r--r--
sql_partition_admin.h	5.73 KB	-rw-r--r--
sql_plist.h	7.55 KB	-rw-r--r--
sql_plugin.h	7.43 KB	-rw-r--r--
sql_plugin_compat.h	2.18 KB	-rw-r--r--
sql_prepare.h	11.14 KB	-rw-r--r--
sql_priv.h	17.05 KB	-rw-r--r--
sql_profile.h	7.51 KB	-rw-r--r--
sql_reload.h	1.01 KB	-rw-r--r--
sql_rename.h	941 B	-rw-r--r--
sql_repl.h	2.96 KB	-rw-r--r--
sql_schema.h	3.69 KB	-rw-r--r--
sql_select.h	85.38 KB	-rw-r--r--
sql_sequence.h	5.06 KB	-rw-r--r--
sql_servers.h	1.74 KB	-rw-r--r--
sql_show.h	9.11 KB	-rw-r--r--
sql_signal.h	3.28 KB	-rw-r--r--
sql_sort.h	4.32 KB	-rw-r--r--
sql_statistics.h	11.96 KB	-rw-r--r--
sql_string.h	34.27 KB	-rw-r--r--
sql_table.h	11.04 KB	-rw-r--r--
sql_tablespace.h	956 B	-rw-r--r--
sql_test.h	1.55 KB	-rw-r--r--
sql_time.h	8.18 KB	-rw-r--r--
sql_trigger.h	10.74 KB	-rw-r--r--
sql_truncate.h	2.02 KB	-rw-r--r--
sql_tvc.h	2.24 KB	-rw-r--r--
sql_type.h	250.17 KB	-rw-r--r--
sql_type_int.h	8.03 KB	-rw-r--r--
sql_type_json.h	1.34 KB	-rw-r--r--
sql_type_real.h	1.23 KB	-rw-r--r--
sql_udf.h	4.43 KB	-rw-r--r--
sql_union.h	1.04 KB	-rw-r--r--
sql_update.h	1.88 KB	-rw-r--r--
sql_view.h	2.33 KB	-rw-r--r--
sql_window.h	6.65 KB	-rw-r--r--
ssl_compat.h	3.13 KB	-rw-r--r--
strfunc.h	2.2 KB	-rw-r--r--
structs.h	24.99 KB	-rw-r--r--
sys_vars_shared.h	2.61 KB	-rw-r--r--
t_ctype.h	5.51 KB	-rw-r--r--
table.h	110.56 KB	-rw-r--r--
table_cache.h	4.44 KB	-rw-r--r--
thr_alarm.h	2.87 KB	-rw-r--r--
thr_lock.h	6.69 KB	-rw-r--r--
thr_malloc.h	1.18 KB	-rw-r--r--
thr_timer.h	1.43 KB	-rw-r--r--
thread_pool_priv.h	4.37 KB	-rw-r--r--
threadpool.h	4.38 KB	-rw-r--r--
transaction.h	1.43 KB	-rw-r--r--
tzfile.h	4.9 KB	-rw-r--r--
tztime.h	3.3 KB	-rw-r--r--
uniques.h	4.05 KB	-rw-r--r--
unireg.h	7.12 KB	-rw-r--r--
vers_string.h	2.87 KB	-rw-r--r--
vers_utils.h	155 B	-rw-r--r--
violite.h	9.54 KB	-rw-r--r--
waiting_threads.h	4.43 KB	-rw-r--r--
welcome_copyright_notice.h	1.19 KB	-rw-r--r--
win_tzname_data.h	6.35 KB	-rw-r--r--
winservice.h	1.17 KB	-rw-r--r--
wqueue.h	1.53 KB	-rw-r--r--
wsrep.h	3.23 KB	-rw-r--r--
wsrep_applier.h	2.71 KB	-rw-r--r--
wsrep_binlog.h	3.36 KB	-rw-r--r--
wsrep_client_service.h	2.31 KB	-rw-r--r--
wsrep_client_state.h	1.53 KB	-rw-r--r--
wsrep_condition_variable.h	1.42 KB	-rw-r--r--
wsrep_high_priority_service.h	4.61 KB	-rw-r--r--
wsrep_mutex.h	1.16 KB	-rw-r--r--
wsrep_mysqld.h	15.87 KB	-rw-r--r--
wsrep_mysqld_c.h	1.2 KB	-rw-r--r--
wsrep_on.h	1.68 KB	-rw-r--r--
wsrep_priv.h	1.6 KB	-rw-r--r--
wsrep_schema.h	4.57 KB	-rw-r--r--
wsrep_server_service.h	3.25 KB	-rw-r--r--
wsrep_server_state.h	2.19 KB	-rw-r--r--
wsrep_sst.h	3.86 KB	-rw-r--r--
wsrep_storage_service.h	1.69 KB	-rw-r--r--
wsrep_thd.h	10.58 KB	-rw-r--r--
wsrep_trans_observer.h	18.72 KB	-rw-r--r--
wsrep_types.h	997 B	-rw-r--r--
wsrep_utils.h	9.07 KB	-rw-r--r--
wsrep_var.h	3.96 KB	-rw-r--r--
wsrep_xid.h	1.32 KB	-rw-r--r--
xa.h	1.46 KB	-rw-r--r--

Code Editor : sql_acl.h

#ifndef SQL_ACL_INCLUDED
#define SQL_ACL_INCLUDED

This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; version 2 of the License.

This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335  USA */

#include "violite.h"                            /* SSL_type */
#include "sql_class.h"                          /* LEX_COLUMN */

#define SELECT_ACL      (1UL << 0)
#define INSERT_ACL      (1UL << 1)
#define UPDATE_ACL      (1UL << 2)
#define DELETE_ACL      (1UL << 3)
#define CREATE_ACL      (1UL << 4)
#define DROP_ACL        (1UL << 5)
#define RELOAD_ACL      (1UL << 6)
#define SHUTDOWN_ACL    (1UL << 7)
#define PROCESS_ACL     (1UL << 8)
#define FILE_ACL        (1UL << 9)
#define GRANT_ACL       (1UL << 10)
#define REFERENCES_ACL  (1UL << 11)
#define INDEX_ACL       (1UL << 12)
#define ALTER_ACL       (1UL << 13)
#define SHOW_DB_ACL     (1UL << 14)
#define SUPER_ACL       (1UL << 15)
#define CREATE_TMP_ACL  (1UL << 16)
#define LOCK_TABLES_ACL (1UL << 17)
#define EXECUTE_ACL     (1UL << 18)
#define REPL_SLAVE_ACL  (1UL << 19)
#define REPL_CLIENT_ACL (1UL << 20)
#define CREATE_VIEW_ACL (1UL << 21)
#define SHOW_VIEW_ACL   (1UL << 22)
#define CREATE_PROC_ACL (1UL << 23)
#define ALTER_PROC_ACL  (1UL << 24)
#define CREATE_USER_ACL (1UL << 25)
#define EVENT_ACL       (1UL << 26)
#define TRIGGER_ACL     (1UL << 27)
#define CREATE_TABLESPACE_ACL (1UL << 28)
#define DELETE_HISTORY_ACL (1UL << 29)
/*
  don't forget to update
  1. static struct show_privileges_st sys_privileges[]
  2. static const char *command_array[] and static uint command_lengths[]
  3. mysql_system_tables.sql and mysql_system_tables_fix.sql
  4. acl_init() or whatever - to define behaviour for old privilege tables
  5. sql_yacc.yy - for GRANT/REVOKE to work
*/
#define NO_ACCESS       (1UL << 30)
#define DB_ACLS \
(UPDATE_ACL | SELECT_ACL | INSERT_ACL | DELETE_ACL | CREATE_ACL | DROP_ACL | \
 GRANT_ACL | REFERENCES_ACL | INDEX_ACL | ALTER_ACL | CREATE_TMP_ACL | \
 LOCK_TABLES_ACL | EXECUTE_ACL | CREATE_VIEW_ACL | SHOW_VIEW_ACL | \
 CREATE_PROC_ACL | ALTER_PROC_ACL | EVENT_ACL | TRIGGER_ACL | \
 DELETE_HISTORY_ACL)

#define COL_ACLS \
(SELECT_ACL | INSERT_ACL | UPDATE_ACL | REFERENCES_ACL)

#define PROC_ACLS \
(ALTER_PROC_ACL | EXECUTE_ACL | GRANT_ACL)

#define SHOW_PROC_ACLS \
(ALTER_PROC_ACL | EXECUTE_ACL | CREATE_PROC_ACL)

#define DEFAULT_CREATE_PROC_ACLS \
(ALTER_PROC_ACL | EXECUTE_ACL)

/**
  Table-level privileges which are automatically "granted" to everyone on
  existing temporary tables (CREATE_ACL is necessary for ALTER ... RENAME).
*/
#define TMP_TABLE_ACLS \
(SELECT_ACL | INSERT_ACL | UPDATE_ACL | DELETE_ACL | CREATE_ACL | DROP_ACL | \
 INDEX_ACL | ALTER_ACL | REFERENCES_ACL)

/*
  Defines to change the above bits to how things are stored in tables
  This is needed as the 'host' and 'db' table is missing a few privileges
*/

/* Privileges that needs to be reallocated (in continous chunks) */
#define DB_CHUNK0 (SELECT_ACL | INSERT_ACL | UPDATE_ACL | DELETE_ACL | \
                   CREATE_ACL | DROP_ACL)
#define DB_CHUNK1 (GRANT_ACL | REFERENCES_ACL | INDEX_ACL | ALTER_ACL)
#define DB_CHUNK2 (CREATE_TMP_ACL | LOCK_TABLES_ACL)
#define DB_CHUNK3 (CREATE_VIEW_ACL | SHOW_VIEW_ACL | \
                   CREATE_PROC_ACL | ALTER_PROC_ACL )
#define DB_CHUNK4 (EXECUTE_ACL)
#define DB_CHUNK5 (EVENT_ACL | TRIGGER_ACL)
#define DB_CHUNK6 (DELETE_HISTORY_ACL)

#define fix_rights_for_db(A)  (((A)       & DB_CHUNK0) | \
                              (((A) << 4) & DB_CHUNK1) | \
                              (((A) << 6) & DB_CHUNK2) | \
                              (((A) << 9) & DB_CHUNK3) | \
                              (((A) << 2) & DB_CHUNK4) | \
                              (((A) << 9) & DB_CHUNK5) | \
                              (((A) << 10) & DB_CHUNK6))
#define get_rights_for_db(A)  (((A) & DB_CHUNK0)       | \
                              (((A) & DB_CHUNK1) >> 4) | \
                              (((A) & DB_CHUNK2) >> 6) | \
                              (((A) & DB_CHUNK3) >> 9) | \
                              (((A) & DB_CHUNK4) >> 2) | \
                              (((A) & DB_CHUNK5) >> 9) | \
                              (((A) & DB_CHUNK6) >> 10))
#define TBL_CHUNK0 DB_CHUNK0
#define TBL_CHUNK1 DB_CHUNK1
#define TBL_CHUNK2 (CREATE_VIEW_ACL | SHOW_VIEW_ACL)
#define TBL_CHUNK3 TRIGGER_ACL
#define TBL_CHUNK4 (DELETE_HISTORY_ACL)
#define fix_rights_for_table(A) (((A)        & TBL_CHUNK0) | \
                                (((A) <<  4) & TBL_CHUNK1) | \
                                (((A) << 11) & TBL_CHUNK2) | \
                                (((A) << 15) & TBL_CHUNK3) | \
                                (((A) << 16) & TBL_CHUNK4))
#define get_rights_for_table(A) (((A) & TBL_CHUNK0)        | \
                                (((A) & TBL_CHUNK1) >>  4) | \
                                (((A) & TBL_CHUNK2) >> 11) | \
                                (((A) & TBL_CHUNK3) >> 15) | \
                                (((A) & TBL_CHUNK4) >> 16))
#define fix_rights_for_column(A) (((A) & 7) | (((A) & ~7) << 8))
#define get_rights_for_column(A) (((A) & 7) | ((A) >> 8))
#define fix_rights_for_procedure(A) ((((A) << 18) & EXECUTE_ACL) | \
                                     (((A) << 23) & ALTER_PROC_ACL) | \
                                     (((A) << 8) & GRANT_ACL))
#define get_rights_for_procedure(A) ((((A) & EXECUTE_ACL) >> 18) |  \
                                     (((A) & ALTER_PROC_ACL) >> 23) | \
                                     (((A) & GRANT_ACL) >> 8))

enum mysql_db_table_field
{
  MYSQL_DB_FIELD_HOST = 0,
  MYSQL_DB_FIELD_DB,
  MYSQL_DB_FIELD_USER,
  MYSQL_DB_FIELD_SELECT_PRIV,
  MYSQL_DB_FIELD_INSERT_PRIV,
  MYSQL_DB_FIELD_UPDATE_PRIV,
  MYSQL_DB_FIELD_DELETE_PRIV,
  MYSQL_DB_FIELD_CREATE_PRIV,
  MYSQL_DB_FIELD_DROP_PRIV,
  MYSQL_DB_FIELD_GRANT_PRIV,
  MYSQL_DB_FIELD_REFERENCES_PRIV,
  MYSQL_DB_FIELD_INDEX_PRIV,
  MYSQL_DB_FIELD_ALTER_PRIV,
  MYSQL_DB_FIELD_CREATE_TMP_TABLE_PRIV,
  MYSQL_DB_FIELD_LOCK_TABLES_PRIV,
  MYSQL_DB_FIELD_CREATE_VIEW_PRIV,
  MYSQL_DB_FIELD_SHOW_VIEW_PRIV,
  MYSQL_DB_FIELD_CREATE_ROUTINE_PRIV,
  MYSQL_DB_FIELD_ALTER_ROUTINE_PRIV,
  MYSQL_DB_FIELD_EXECUTE_PRIV,
  MYSQL_DB_FIELD_EVENT_PRIV,
  MYSQL_DB_FIELD_TRIGGER_PRIV,
  MYSQL_DB_FIELD_DELETE_VERSIONING_ROWS_PRIV,
  MYSQL_DB_FIELD_COUNT
};

extern const TABLE_FIELD_DEF mysql_db_table_def;
extern bool mysql_user_table_is_in_short_password_format;

extern LEX_CSTRING host_not_specified;
extern LEX_CSTRING current_user;
extern LEX_CSTRING current_role;
extern LEX_CSTRING current_user_and_current_role;

static inline int access_denied_error_code(int passwd_used)
{
#ifdef mysqld_error_find_printf_error_used
  return 0;
#else
  return passwd_used == 2 ? ER_ACCESS_DENIED_NO_PASSWORD_ERROR
                          : ER_ACCESS_DENIED_ERROR;
#endif
}

/* prototypes */

bool hostname_requires_resolving(const char *hostname);
bool  acl_init(bool dont_read_acl_tables);
bool acl_reload(THD *thd);
void acl_free(bool end=0);
ulong acl_get(const char *host, const char *ip,
              const char *user, const char *db, my_bool db_is_pattern);
bool acl_authenticate(THD *thd, uint com_change_user_pkt_len);
bool acl_getroot(Security_context *sctx, const char *user, const char *host,
                 const char *ip, const char *db);
bool acl_check_host(const char *host, const char *ip);
bool check_change_password(THD *thd, LEX_USER *user);
bool change_password(THD *thd, LEX_USER *user);

bool mysql_grant_role(THD *thd, List<LEX_USER> &user_list, bool revoke);
bool mysql_grant(THD *thd, const char *db, List <LEX_USER> &user_list,
                 ulong rights, bool revoke, bool is_proxy);
int mysql_table_grant(THD *thd, TABLE_LIST *table, List <LEX_USER> &user_list,
                       List <LEX_COLUMN> &column_list, ulong rights,
                       bool revoke);
bool mysql_routine_grant(THD *thd, TABLE_LIST *table, const Sp_handler *sph,
                         List <LEX_USER> &user_list, ulong rights,
                         bool revoke, bool write_to_binlog);
bool grant_init();
void grant_free(void);
bool grant_reload(THD *thd);
bool check_grant(THD *thd, ulong want_access, TABLE_LIST *tables,
                 bool any_combination_will_do, uint number, bool no_errors);
bool check_grant_column (THD *thd, GRANT_INFO *grant,
                         const char *db_name, const char *table_name,
                         const char *name, size_t length, Security_context *sctx);
bool check_column_grant_in_table_ref(THD *thd, TABLE_LIST * table_ref,
                                     const char *name, size_t length, Field *fld);
bool check_grant_all_columns(THD *thd, ulong want_access,
                             Field_iterator_table_ref *fields);
bool check_grant_routine(THD *thd, ulong want_access,
                         TABLE_LIST *procs, const Sp_handler *sph,
                         bool no_error);
bool check_grant_db(THD *thd,const char *db);
bool check_global_access(THD *thd, ulong want_access, bool no_errors= false);
bool check_access(THD *thd, ulong want_access, const char *db, ulong *save_priv,
                  GRANT_INTERNAL_INFO *grant_internal_info,
                  bool dont_check_global_grants, bool no_errors);
ulong get_table_grant(THD *thd, TABLE_LIST *table);
ulong get_column_grant(THD *thd, GRANT_INFO *grant,
                       const char *db_name, const char *table_name,
                       const char *field_name);
bool get_show_user(THD *thd, LEX_USER *lex_user, const char **username,
                   const char **hostname, const char **rolename);
void mysql_show_grants_get_fields(THD *thd, List<Item> *fields,
                                  const char *name, size_t length);
bool mysql_show_grants(THD *thd, LEX_USER *user);
bool mysql_show_create_user(THD *thd, LEX_USER *user);
int fill_schema_enabled_roles(THD *thd, TABLE_LIST *tables, COND *cond);
int fill_schema_applicable_roles(THD *thd, TABLE_LIST *tables, COND *cond);
void get_privilege_desc(char *to, uint max_length, ulong access);
void get_mqh(const char *user, const char *host, USER_CONN *uc);
bool mysql_create_user(THD *thd, List <LEX_USER> &list, bool handle_as_role);
bool mysql_drop_user(THD *thd, List <LEX_USER> &list, bool handle_as_role);
bool mysql_rename_user(THD *thd, List <LEX_USER> &list);
int mysql_alter_user(THD *thd, List <LEX_USER> &list);
bool mysql_revoke_all(THD *thd, List <LEX_USER> &list);
void fill_effective_table_privileges(THD *thd, GRANT_INFO *grant,
                                     const char *db, const char *table);
bool sp_revoke_privileges(THD *thd, const char *sp_db, const char *sp_name,
                          const Sp_handler *sph);
bool sp_grant_privileges(THD *thd, const char *sp_db, const char *sp_name,
                         const Sp_handler *sph);
bool check_routine_level_acl(THD *thd, const char *db, const char *name,
                             const Sp_handler *sph);
bool is_acl_user(const char *host, const char *user);
int fill_schema_user_privileges(THD *thd, TABLE_LIST *tables, COND *cond);
int fill_schema_schema_privileges(THD *thd, TABLE_LIST *tables, COND *cond);
int fill_schema_table_privileges(THD *thd, TABLE_LIST *tables, COND *cond);
int fill_schema_column_privileges(THD *thd, TABLE_LIST *tables, COND *cond);
int wild_case_compare(CHARSET_INFO *cs, const char *str,const char *wildstr);

/**
  Result of an access check for an internal schema or table.
  Internal ACL checks are always performed *before* using
  the grant tables.
  This mechanism enforces that the server implementation has full
  control on its internal tables.
  Depending on the internal check result, the server implementation
  can choose to:
  - always allow access,
  - always deny access,
  - delegate the decision to the database administrator,
  by using the grant tables.
*/
enum ACL_internal_access_result
{
  /**
    Access granted for all the requested privileges,
    do not use the grant tables.
    This flag is used only for the INFORMATION_SCHEMA privileges,
    for compatibility reasons.
  */
  ACL_INTERNAL_ACCESS_GRANTED,
  /** Access denied, do not use the grant tables. */
  ACL_INTERNAL_ACCESS_DENIED,
  /** No decision yet, use the grant tables. */
  ACL_INTERNAL_ACCESS_CHECK_GRANT
};

/**
  Per internal table ACL access rules.
  This class is an interface.
  Per table(s) specific access rule should be implemented in a subclass.
  @sa ACL_internal_schema_access
*/
class ACL_internal_table_access
{
public:
  ACL_internal_table_access() = default;

virtual ~ACL_internal_table_access() = default;

/**
    Check access to an internal table.
    When a privilege is granted, this method add the requested privilege
    to save_priv.
    @param want_access the privileges requested
    @param [in, out] save_priv the privileges granted
    @return
      @retval ACL_INTERNAL_ACCESS_GRANTED All the requested privileges
      are granted, and saved in save_priv.
      @retval ACL_INTERNAL_ACCESS_DENIED At least one of the requested
      privileges was denied.
      @retval ACL_INTERNAL_ACCESS_CHECK_GRANT No requested privilege
      was denied, and grant should be checked for at least one
      privilege. Requested privileges that are granted, if any, are saved
      in save_priv.
  */
  virtual ACL_internal_access_result check(ulong want_access,
                                           ulong *save_priv) const= 0;
};

/**
  Per internal schema ACL access rules.
  This class is an interface.
  Each per schema specific access rule should be implemented
  in a different subclass, and registered.
  Per schema access rules can control:
  - every schema privileges on schema.*
  - every table privileges on schema.table
  @sa ACL_internal_schema_registry
*/
class ACL_internal_schema_access
{
public:
  ACL_internal_schema_access() = default;

virtual ~ACL_internal_schema_access() = default;

/**
    Check access to an internal schema.
    @param want_access the privileges requested
    @param [in, out] save_priv the privileges granted
    @return
      @retval ACL_INTERNAL_ACCESS_GRANTED All the requested privileges
      are granted, and saved in save_priv.
      @retval ACL_INTERNAL_ACCESS_DENIED At least one of the requested
      privileges was denied.
      @retval ACL_INTERNAL_ACCESS_CHECK_GRANT No requested privilege
      was denied, and grant should be checked for at least one
      privilege. Requested privileges that are granted, if any, are saved
      in save_priv.
  */
  virtual ACL_internal_access_result check(ulong want_access,
                                           ulong *save_priv) const= 0;

/**
    Search for per table ACL access rules by table name.
    @param name the table name
    @return per table access rules, or NULL
  */
  virtual const ACL_internal_table_access *lookup(const char *name) const= 0;
};

/**
  A registry for per internal schema ACL.
  An 'internal schema' is a database schema maintained by the
  server implementation, such as 'performance_schema' and 'INFORMATION_SCHEMA'.
*/
class ACL_internal_schema_registry
{
public:
  static void register_schema(const LEX_CSTRING *name,
                              const ACL_internal_schema_access *access);
  static const ACL_internal_schema_access *lookup(const char *name);
};

const ACL_internal_schema_access *
get_cached_schema_access(GRANT_INTERNAL_INFO *grant_internal_info,
                         const char *schema_name);

const ACL_internal_table_access *
get_cached_table_access(GRANT_INTERNAL_INFO *grant_internal_info,
                        const char *schema_name,
                        const char *table_name);

bool acl_check_proxy_grant_access (THD *thd, const char *host, const char *user,
                                   bool with_grant);
int acl_setrole(THD *thd, const char *rolename, ulonglong access);
int acl_check_setrole(THD *thd, const char *rolename, ulonglong *access);
int acl_check_set_default_role(THD *thd, const char *host, const char *user,
                               const char *role);
int acl_set_default_role(THD *thd, const char *host, const char *user,
                         const char *rolename);

extern SHOW_VAR acl_statistics[];

/* Check if a role is granted to a user/role.

If hostname == NULL, search for a role as the starting grantee.
*/
bool check_role_is_granted(const char *username,
                           const char *hostname,
                           const char *rolename);

#ifndef DBUG_OFF
extern ulong role_global_merges, role_db_merges, role_table_merges,
             role_column_merges, role_routine_merges;
#endif
#endif /* SQL_ACL_INCLUDED */

${this.title}

Code Editor : sql_acl.h