/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB 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; either version 2 of the License, or (at your option) any later version. 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., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ #define SELECT_ACL 1 #define INSERT_ACL 2 #define UPDATE_ACL 4 #define DELETE_ACL 8 #define CREATE_ACL 16 #define DROP_ACL 32 #define RELOAD_ACL 64 #define SHUTDOWN_ACL 128 #define PROCESS_ACL 256 #define FILE_ACL 512 #define GRANT_ACL 1024 #define REFERENCES_ACL 2048 #define INDEX_ACL 4096 #define ALTER_ACL 8192 #define EXTRA_ACL 16384 #define DB_ACLS (UPDATE_ACL | SELECT_ACL | INSERT_ACL | \ DELETE_ACL | CREATE_ACL | DROP_ACL | GRANT_ACL | \ REFERENCES_ACL | INDEX_ACL | ALTER_ACL) #define TABLE_ACLS (SELECT_ACL | INSERT_ACL | UPDATE_ACL | \ DELETE_ACL | CREATE_ACL | DROP_ACL | GRANT_ACL | \ REFERENCES_ACL | INDEX_ACL | ALTER_ACL) #define COL_ACLS (SELECT_ACL | INSERT_ACL | UPDATE_ACL | REFERENCES_ACL) #define GLOBAL_ACLS (SELECT_ACL | INSERT_ACL | UPDATE_ACL | DELETE_ACL |\ CREATE_ACL | DROP_ACL | RELOAD_ACL | SHUTDOWN_ACL |\ PROCESS_ACL | FILE_ACL | GRANT_ACL | REFERENCES_ACL |\ INDEX_ACL | ALTER_ACL) #define NO_ACCESS 32768 /* defines to change the above bits to how things are stored in tables */ #define fix_rights_for_db(A) (((A) & 63) | (((A) & ~63) << 4)) #define get_rights_for_db(A) (((A) & 63) | (((A) & ~63) >> 4)) #define fix_rights_for_table(A) (((A) & 63) | (((A) & ~63) << 4)) #define get_rights_for_table(A) (((A) & 63) | (((A) & ~63) >> 4)) #define fix_rights_for_column(A) (((A) & COL_ACLS) | ((A & ~COL_ACLS) << 7)) #define get_rights_for_column(A) (((A) & COL_ACLS) | ((A & ~COL_ACLS) >> 7)) /* prototypes */ int acl_init(bool dont_read_acl_tables); void acl_reload(void); void acl_free(bool end=0); uint acl_get(const char *host, const char *ip, const char *bin_ip, const char *user, const char *db); uint acl_getroot(THD *thd, const char *host, const char *ip, const char *user, const char *password,const char *scramble,char **priv_user, bool old_ver, USER_RESOURCES *max); bool acl_check_host(const char *host, const char *ip); bool change_password(THD *thd, const char *host, const char *user, char *password); int mysql_grant(THD *thd, const char *db, List &user_list, uint rights, bool revoke); int mysql_table_grant(THD *thd, TABLE_LIST *table, List &user_list, List &column_list, uint rights, bool revoke); int grant_init(void); void grant_free(void); void grant_reload(void); bool check_grant(THD *thd, uint want_access, TABLE_LIST *tables, uint show_command=0, bool dont_print_error=0); bool check_grant_column (THD *thd,TABLE *table, const char *name,uint length, uint show_command=0); bool check_grant_all_columns(THD *thd, uint want_access, TABLE *table); bool check_grant_db(THD *thd,const char *db); uint get_table_grant(THD *thd, TABLE_LIST *table); uint get_column_grant(THD *thd, TABLE_LIST *table, Field *field); int mysql_show_grants(THD *thd, LEX_USER *user); void get_mqh(const char *user, const char *host, USER_CONN *uc);