sql_acl.cc 87.1 KB
Newer Older
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1
/* Copyright (C) 2000 MySQL AB
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3 4 5 6
   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.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
7

bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11
   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.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
   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 */


/*
  The privileges are saved in the following tables:
  mysql/user	 ; super user who are allowed to do almoust anything
  mysql/host	 ; host priviliges. This is used if host is empty in mysql/db.
  mysql/db	 ; database privileges / user

  data in tables is sorted according to how many not-wild-cards there is
  in the relevant fields. Empty strings comes last.
*/

#include "mysql_priv.h"
#include "sql_acl.h"
#include "hash_filo.h"
#include <m_ctype.h>
32
#include <assert.h>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
33 34 35 36 37 38 39 40
#include <stdarg.h>

struct acl_host_and_ip
{
  char *hostname;
  long ip,ip_mask;			// Used with masked ip:s
};

41

bk@work.mysql.com's avatar
bk@work.mysql.com committed
42 43 44
class ACL_ACCESS {
public:
  ulong sort;
45
  ulong access;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
46 47
};

48 49 50

/* ACL_HOST is used if no host is specified */

bk@work.mysql.com's avatar
bk@work.mysql.com committed
51 52 53 54 55 56 57
class ACL_HOST :public ACL_ACCESS
{
public:
  acl_host_and_ip host;
  char *db;
};

58

bk@work.mysql.com's avatar
bk@work.mysql.com committed
59 60 61 62
class ACL_USER :public ACL_ACCESS
{
public:
  acl_host_and_ip host;
63 64
  uint hostname_length;
  USER_RESOURCES user_resource;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
65 66
  char *user,*password;
  ulong salt[2];
67 68
  enum SSL_type ssl_type;
  const char *ssl_cipher, *x509_issuer, *x509_subject;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
69 70
};

71

bk@work.mysql.com's avatar
bk@work.mysql.com committed
72 73 74 75 76 77 78
class ACL_DB :public ACL_ACCESS
{
public:
  acl_host_and_ip host;
  char *user,*db;
};

79

bk@work.mysql.com's avatar
bk@work.mysql.com committed
80 81 82
class acl_entry :public hash_filo_element
{
public:
83
  ulong access;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
84 85 86 87
  uint16 length;
  char key[1];					// Key will be stored here
};

88

bk@work.mysql.com's avatar
bk@work.mysql.com committed
89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
static byte* acl_entry_get_key(acl_entry *entry,uint *length,
			       my_bool not_used __attribute__((unused)))
{
  *length=(uint) entry->length;
  return (byte*) entry->key;
}

#define ACL_KEY_LENGTH (sizeof(long)+NAME_LEN+17)

static DYNAMIC_ARRAY acl_hosts,acl_users,acl_dbs;
static MEM_ROOT mem, memex;
static bool initialized=0;
static bool allow_all_hosts=1;
static HASH acl_check_hosts, hash_tables;
static DYNAMIC_ARRAY acl_wild_hosts;
static hash_filo *acl_cache;
static uint grant_version=0;
106
static ulong get_access(TABLE *form,uint fieldnr);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
107 108 109 110 111 112 113 114 115 116
static int acl_compare(ACL_ACCESS *a,ACL_ACCESS *b);
static ulong get_sort(uint count,...);
static void init_check_host(void);
static ACL_USER *find_acl_user(const char *host, const char *user);
static bool update_user_table(THD *thd, const char *host, const char *user,
			      const char *new_password);
static void update_hostname(acl_host_and_ip *host, const char *hostname);
static bool compare_hostname(const acl_host_and_ip *host, const char *hostname,
			     const char *ip);

117 118 119 120 121
/*
  Read grant privileges from the privilege tables in the 'mysql' database.

  SYNOPSIS
    acl_init()
122
    thd				Thread handler
123 124 125 126 127 128 129 130
    dont_read_acl_tables	Set to 1 if run with --skip-grant

  RETURN VALUES
    0	ok
    1	Could not initialize grant's
*/


131
my_bool acl_init(THD *org_thd, bool dont_read_acl_tables)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
132
{
133
  THD  *thd;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
134 135 136
  TABLE_LIST tables[3];
  TABLE *table;
  READ_RECORD read_record_info;
137 138
  MYSQL_LOCK *lock;
  my_bool return_val=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
139 140 141 142 143
  DBUG_ENTER("acl_init");

  if (!acl_cache)
    acl_cache=new hash_filo(ACL_CACHE_SIZE,0,0,
			    (hash_get_key) acl_entry_get_key,
144
			    (hash_free_key) free);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
145 146 147
  if (dont_read_acl_tables)
    DBUG_RETURN(0); /* purecov: tested */

148 149 150
  /*
    To be able to run this from boot, we allocate a temporary THD
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
151 152
  if (!(thd=new THD))
    DBUG_RETURN(1); /* purecov: inspected */
153 154
  thd->store_globals();

bk@work.mysql.com's avatar
bk@work.mysql.com committed
155
  acl_cache->clear(1);				// Clear locked hostname cache
156 157
  thd->db= my_strdup("mysql",MYF(0));
  thd->db_length=5;				// Safety
bk@work.mysql.com's avatar
bk@work.mysql.com committed
158
  bzero((char*) &tables,sizeof(tables));
159 160 161
  tables[0].alias=tables[0].real_name=(char*) "host";
  tables[1].alias=tables[1].real_name=(char*) "user";
  tables[2].alias=tables[2].real_name=(char*) "db";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
162 163 164 165 166 167
  tables[0].next=tables+1;
  tables[1].next=tables+2;
  tables[0].lock_type=tables[1].lock_type=tables[2].lock_type=TL_READ;
  tables[0].db=tables[1].db=tables[2].db=thd->db;

  if (open_tables(thd,tables))
168 169 170
  {
    sql_print_error("Fatal error: Can't open privilege tables: %s",
		    thd->net.last_error);
171
    goto end;
172
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
173 174 175 176
  TABLE *ptr[3];				// Lock tables for quick update
  ptr[0]= tables[0].table;
  ptr[1]= tables[1].table;
  ptr[2]= tables[2].table;
177
  if (!(lock=mysql_lock_tables(thd,ptr,3)))
178 179 180
  {
    sql_print_error("Fatal error: Can't lock privilege tables: %s",
		    thd->net.last_error);
181
    goto end;
182
  }
183
  init_sql_alloc(&mem,1024,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
184
  init_read_record(&read_record_info,thd,table= tables[0].table,NULL,1,0);
185
  VOID(my_init_dynamic_array(&acl_hosts,sizeof(ACL_HOST),20,50));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
186 187 188 189
  while (!(read_record_info.read_record(&read_record_info)))
  {
    ACL_HOST host;
    update_hostname(&host.host,get_field(&mem, table,0));
190 191 192 193
    host.db=	 get_field(&mem, table,1);
    host.access= get_access(table,2);
    host.access= fix_rights_for_db(host.access);
    host.sort=   get_sort(2,host.host.hostname,host.db);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
194 195 196 197
#ifndef TO_BE_REMOVED
    if (table->fields ==  8)
    {						// Without grant
      if (host.access & CREATE_ACL)
198
	host.access|=REFERENCES_ACL | INDEX_ACL | ALTER_ACL | CREATE_TMP_ACL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
199 200 201 202 203 204 205 206 207 208
    }
#endif
    VOID(push_dynamic(&acl_hosts,(gptr) &host));
  }
  qsort((gptr) dynamic_element(&acl_hosts,0,ACL_HOST*),acl_hosts.elements,
	sizeof(ACL_HOST),(qsort_cmp) acl_compare);
  end_read_record(&read_record_info);
  freeze_size(&acl_hosts);

  init_read_record(&read_record_info,thd,table=tables[1].table,NULL,1,0);
209
  VOID(my_init_dynamic_array(&acl_users,sizeof(ACL_USER),50,100));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
210 211 212 213 214 215 216 217
  if (table->field[2]->field_length == 8 &&
      protocol_version == PROTOCOL_VERSION)
  {
    sql_print_error(
	    "Old 'user' table. (Check README or the Reference manual). Continuing --old-protocol"); /* purecov: tested */
    protocol_version=9; /* purecov: tested */
  }

218
  DBUG_PRINT("info",("user table fields: %d",table->fields));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
219 220 221 222 223 224 225 226
  allow_all_hosts=0;
  while (!(read_record_info.read_record(&read_record_info)))
  {
    ACL_USER user;
    uint length=0;
    update_hostname(&user.host,get_field(&mem, table,0));
    user.user=get_field(&mem, table,1);
    user.password=get_field(&mem, table,2);
227
    if (user.password && (length=(uint) strlen(user.password)) == 8 &&
bk@work.mysql.com's avatar
bk@work.mysql.com committed
228 229 230
	protocol_version == PROTOCOL_VERSION)
    {
      sql_print_error(
231
		      "Found old style password for user '%s'. Ignoring user. (You may want to restart mysqld using --old-protocol)",
bk@work.mysql.com's avatar
bk@work.mysql.com committed
232 233 234 235 236 237 238 239
		      user.user ? user.user : ""); /* purecov: tested */
    }
    else if (length % 8)		// This holds true for passwords
    {
      sql_print_error(
		      "Found invalid password for user: '%s@%s'; Ignoring user",
		      user.user ? user.user : "",
		      user.host.hostname ? user.host.hostname : ""); /* purecov: tested */
240
      continue;					/* purecov: tested */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
241 242
    }
    get_salt_from_password(user.salt,user.password);
243
    user.access=get_access(table,3) & GLOBAL_ACLS;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
244
    user.sort=get_sort(2,user.host.hostname,user.user);
245 246
    user.hostname_length= (user.host.hostname ?
			   (uint) strlen(user.host.hostname) : 0);
247
    if (table->fields >= 31)     /* Starting from 4.0.2 we have more fields */
248
    {
249 250 251 252 253 254 255 256 257 258 259 260 261
      char *ssl_type=get_field(&mem, table, 24);
      if (!ssl_type)
	user.ssl_type=SSL_TYPE_NONE;
      else if (!strcmp(ssl_type, "ANY"))
	user.ssl_type=SSL_TYPE_ANY;
      else if (!strcmp(ssl_type, "X509"))
	user.ssl_type=SSL_TYPE_X509;
      else  /* !strcmp(ssl_type, "SPECIFIED") */
	user.ssl_type=SSL_TYPE_SPECIFIED;

      user.ssl_cipher=   get_field(&mem, table, 25);
      user.x509_issuer=  get_field(&mem, table, 26);
      user.x509_subject= get_field(&mem, table, 27);
262

263
      char *ptr = get_field(&mem, table, 28);
264
      user.user_resource.questions=atoi(ptr);
265
      ptr = get_field(&mem, table, 29);
266
      user.user_resource.updates=atoi(ptr);
267
      ptr = get_field(&mem, table, 30);
268
      user.user_resource.connections=atoi(ptr);
269 270
      if (user.user_resource.questions || user.user_resource.updates ||
	  user.user_resource.connections)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
271
	mqh_used=1;
272
    }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
273
    else
274 275
    {
      user.ssl_type=SSL_TYPE_NONE;
276
      bzero(&(user.user_resource),sizeof(user.user_resource));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
277
#ifndef TO_BE_REMOVED
278 279 280 281 282 283
      if (table->fields <= 13)
      {						// Without grant
	if (user.access & CREATE_ACL)
	  user.access|=REFERENCES_ACL | INDEX_ACL | ALTER_ACL;
      }
      /* Convert old privileges */
284
      user.access|= LOCK_TABLES_ACL | CREATE_TMP_ACL | SHOW_DB_ACL;
285 286 287 288
      if (user.access & FILE_ACL)
	user.access|= REPL_CLIENT_ACL | REPL_SLAVE_ACL;
      if (user.access & PROCESS_ACL)
	user.access|= SUPER_ACL | EXECUTE_ACL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
289
#endif
290
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
291 292 293 294 295 296 297 298 299 300 301
    VOID(push_dynamic(&acl_users,(gptr) &user));
    if (!user.host.hostname || user.host.hostname[0] == wild_many &&
	!user.host.hostname[1])
      allow_all_hosts=1;			// Anyone can connect
  }
  qsort((gptr) dynamic_element(&acl_users,0,ACL_USER*),acl_users.elements,
	sizeof(ACL_USER),(qsort_cmp) acl_compare);
  end_read_record(&read_record_info);
  freeze_size(&acl_users);

  init_read_record(&read_record_info,thd,table=tables[2].table,NULL,1,0);
302
  VOID(my_init_dynamic_array(&acl_dbs,sizeof(ACL_DB),50,100));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
303 304 305 306 307
  while (!(read_record_info.read_record(&read_record_info)))
  {
    ACL_DB db;
    update_hostname(&db.host,get_field(&mem, table,0));
    db.db=get_field(&mem, table,1);
308 309 310
    if (!db.db)
    {
      sql_print_error("Found an entry in the 'db' table with empty database name; Skipped");
311
      continue;
312
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332
    db.user=get_field(&mem, table,2);
    db.access=get_access(table,3);
    db.access=fix_rights_for_db(db.access);
    db.sort=get_sort(3,db.host.hostname,db.db,db.user);
#ifndef TO_BE_REMOVED
    if (table->fields <=  9)
    {						// Without grant
      if (db.access & CREATE_ACL)
	db.access|=REFERENCES_ACL | INDEX_ACL | ALTER_ACL;
    }
#endif
    VOID(push_dynamic(&acl_dbs,(gptr) &db));
  }
  qsort((gptr) dynamic_element(&acl_dbs,0,ACL_DB*),acl_dbs.elements,
	sizeof(ACL_DB),(qsort_cmp) acl_compare);
  end_read_record(&read_record_info);
  freeze_size(&acl_dbs);
  init_check_host();

  mysql_unlock_tables(thd, lock);
333
  initialized=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
334
  thd->version--;				// Force close to free memory
335 336 337
  return_val=0;

end:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
338 339
  close_thread_tables(thd);
  delete thd;
340 341
  if (org_thd)
    org_thd->store_globals();			/* purecov: inspected */
342 343 344 345 346
  else
  {
    /* Remember that we don't have a THD */
    my_pthread_setspecific_ptr(THR_THD,  0);
  }
347
  DBUG_RETURN(return_val);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
348 349 350 351 352
}


void acl_free(bool end)
{
353
  free_root(&mem,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369
  delete_dynamic(&acl_hosts);
  delete_dynamic(&acl_users);
  delete_dynamic(&acl_dbs);
  delete_dynamic(&acl_wild_hosts);
  hash_free(&acl_check_hosts);
  if (!end)
    acl_cache->clear(1); /* purecov: inspected */
  else
  {
    delete acl_cache;
    acl_cache=0;
  }
}

	/* Reload acl list if possible */

370
void acl_reload(THD *thd)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
371 372 373 374 375 376
{
  DYNAMIC_ARRAY old_acl_hosts,old_acl_users,old_acl_dbs;
  MEM_ROOT old_mem;
  bool old_initialized;
  DBUG_ENTER("acl_reload");

377
  if (thd && thd->locked_tables)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
378
  {					// Can't have locked tables here
379 380 381
    thd->lock=thd->locked_tables;
    thd->locked_tables=0;
    close_thread_tables(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
382 383 384 385 386 387 388 389 390 391 392
  }
  if ((old_initialized=initialized))
    VOID(pthread_mutex_lock(&acl_cache->lock));

  old_acl_hosts=acl_hosts;
  old_acl_users=acl_users;
  old_acl_dbs=acl_dbs;
  old_mem=mem;
  delete_dynamic(&acl_wild_hosts);
  hash_free(&acl_check_hosts);

393
  if (acl_init(thd, 0))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
394
  {					// Error. Revert to old list
395
    acl_free();				/* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
396 397 398 399 400 401 402 403
    acl_hosts=old_acl_hosts;
    acl_users=old_acl_users;
    acl_dbs=old_acl_dbs;
    mem=old_mem;
    init_check_host();
  }
  else
  {
404
    free_root(&old_mem,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
405 406 407 408 409 410 411 412 413 414
    delete_dynamic(&old_acl_hosts);
    delete_dynamic(&old_acl_users);
    delete_dynamic(&old_acl_dbs);
  }
  if (old_initialized)
    VOID(pthread_mutex_unlock(&acl_cache->lock));
  DBUG_VOID_RETURN;
}


415 416 417 418 419
/*
  Get all access bits from table after fieldnr
  We know that the access privileges ends when there is no more fields
  or the field is not an enum with two elements.
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
420

421
static ulong get_access(TABLE *form, uint fieldnr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
422
{
423
  ulong access_bits=0,bit;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
424
  char buff[2];
425
  String res(buff,sizeof(buff),default_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
426 427
  Field **pos;

428 429 430 431
  for (pos=form->field+fieldnr, bit=1;
       *pos && (*pos)->real_type() == FIELD_TYPE_ENUM &&
	 ((Field_enum*) (*pos))->typelib->count == 2 ;
       pos++ , bit<<=1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
432 433
  {
    (*pos)->val_str(&res,&res);
434
    if (my_toupper(system_charset_info, res[0]) == 'Y')
435
      access_bits|= bit;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
436 437 438 439 440 441
  }
  return access_bits;
}


/*
442 443 444 445 446
  Return a number which, if sorted 'desc', puts strings in this order:
    no wildcards
    wildcards
    empty string
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485

static ulong get_sort(uint count,...)
{
  va_list args;
  va_start(args,count);
  ulong sort=0;

  while (count--)
  {
    char *str=va_arg(args,char*);
    uint chars=0,wild=0;

    if (str)
    {
      for (; *str ; str++)
      {
	if (*str == wild_many || *str == wild_one || *str == wild_prefix)
	  wild++;
	else
	  chars++;
      }
    }
    sort= (sort << 8) + (wild ? 1 : chars ? 2 : 0);
  }
  va_end(args);
  return sort;
}


static int acl_compare(ACL_ACCESS *a,ACL_ACCESS *b)
{
  if (a->sort > b->sort)
    return -1;
  if (a->sort < b->sort)
    return 1;
  return 0;
}


monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
486 487 488 489 490
/*
  Get master privilges for user (priviliges for all tables).
  Required before connecting to MySQL
*/

491 492 493
ulong acl_getroot(THD *thd, const char *host, const char *ip, const char *user,
		  const char *password,const char *message,char **priv_user,
		  bool old_ver, USER_RESOURCES  *mqh)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
494
{
495
  ulong user_access=NO_ACCESS;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
496
  *priv_user=(char*) user;
497
  DBUG_ENTER("acl_getroot");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
498

499
  bzero(mqh,sizeof(USER_RESOURCES));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
500
  if (!initialized)
501 502 503 504
  {
    // If no data allow anything
    DBUG_RETURN((ulong) ~NO_ACCESS);		/* purecov: tested */
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522
  VOID(pthread_mutex_lock(&acl_cache->lock));

  /*
    Get possible access from user_list. This is or'ed to others not
    fully specified
  */
  for (uint i=0 ; i < acl_users.elements ; i++)
  {
    ACL_USER *acl_user=dynamic_element(&acl_users,i,ACL_USER*);
    if (!acl_user->user || !strcmp(user,acl_user->user))
    {
      if (compare_hostname(&acl_user->host,host,ip))
      {
	if (!acl_user->password && !*password ||
	    (acl_user->password && *password &&
	     !check_scramble(password,message,acl_user->salt,
			     (my_bool) old_ver)))
	{
523
#ifdef HAVE_OPENSSL
524 525 526 527 528 529 530
	  Vio *vio=thd->net.vio;
          /*
	    In this point we know that user is allowed to connect 
	    from given host by given username/password pair. Now 
	    we check if SSL is required, if user is using SSL and 
	    if X509 certificate attributes are OK 
	  */
531
          switch (acl_user->ssl_type) {
532
	  case SSL_TYPE_NOT_SPECIFIED:		// Impossible
533
          case SSL_TYPE_NONE: /* SSL is not required to connect */
534 535
	    user_access=acl_user->access;
	    break;
536
	  case SSL_TYPE_ANY: /* Any kind of SSL is good enough */
537 538 539
	    if (vio_type(vio) == VIO_TYPE_SSL)
	      user_access=acl_user->access;
	    break;
540
	  case SSL_TYPE_X509: /* Client should have any valid certificate. */
541 542 543 544 545 546 547 548 549 550 551 552 553 554 555
	    /*
	      Connections with non-valid certificates are dropped already 
	      in sslaccept() anyway, so we do not check validity here. 
	    */
	    if (SSL_get_peer_certificate(vio->ssl_))
	      user_access=acl_user->access;
	    break;
	  case SSL_TYPE_SPECIFIED: /* Client should have specified attrib */
	    /*
	      We do not check for absence of SSL because without SSL it does
	      not pass all checks here anyway.
	      If cipher name is specified, we compare it to actual cipher in
	      use.
	    */
	    if (acl_user->ssl_cipher)
556
	    {
557 558 559
	      DBUG_PRINT("info",("comparing ciphers: '%s' and '%s'",
				 acl_user->ssl_cipher,
				 SSL_get_cipher(vio->ssl_)));
560 561 562 563 564 565 566
	      if (!strcmp(acl_user->ssl_cipher,SSL_get_cipher(vio->ssl_)))
		user_access=acl_user->access;
	      else
	      {
		user_access=NO_ACCESS;
		break;
	      }
567 568 569 570 571 572 573 574 575
	    }
	    /* Prepare certificate (if exists) */
	    DBUG_PRINT("info",("checkpoint 1"));
	    X509* cert=SSL_get_peer_certificate(vio->ssl_);
	    DBUG_PRINT("info",("checkpoint 2"));
	    /* If X509 issuer is speified, we check it... */
	    if (acl_user->x509_issuer) 
	    {
	      DBUG_PRINT("info",("checkpoint 3"));
576
	      char *ptr = X509_NAME_oneline(X509_get_issuer_name(cert), 0, 0);
577 578
	      DBUG_PRINT("info",("comparing issuers: '%s' and '%s'",
				 acl_user->x509_issuer, ptr));
579
	      if (strcmp(acl_user->x509_issuer, ptr))
580 581 582 583 584
	      {
		user_access=NO_ACCESS;
		free(ptr);
		break;
	      }
585
	      user_access=acl_user->access;
586 587 588 589 590 591
	      free(ptr);
	    }
	    DBUG_PRINT("info",("checkpoint 4"));
	    /* X509 subject is specified, we check it .. */
	    if (acl_user->x509_subject)
	    {
592
	      char *ptr= X509_NAME_oneline(X509_get_subject_name(cert), 0, 0);
593 594
	      DBUG_PRINT("info",("comparing subjects: '%s' and '%s'",
				 acl_user->x509_subject, ptr));
595
	      if (strcmp(acl_user->x509_subject,ptr))
596
		user_access=NO_ACCESS;
597 598
	      else
		user_access=acl_user->access;
599 600 601
	      free(ptr);
	    }
	    break;
602 603
	  }
#else  /* HAVE_OPENSSL */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
604
	  user_access=acl_user->access;
605
#endif /* HAVE_OPENSSL */
606
	  *mqh=acl_user->user_resource;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
607 608 609 610 611 612 613 614 615 616 617
	  if (!acl_user->user)
	    *priv_user=(char*) "";	// Change to anonymous user /* purecov: inspected */
	  break;
	}
#ifndef ALLOW_DOWNGRADE_OF_USERS
	break;				// Wrong password breaks loop /* purecov: inspected */
#endif
      }
    }
  }
  VOID(pthread_mutex_unlock(&acl_cache->lock));
618
  DBUG_RETURN(user_access);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634
}


/*
** Functions to add and change user and database privileges when one
** changes things with GRANT
*/

static byte* check_get_key(ACL_USER *buff,uint *length,
			   my_bool not_used __attribute__((unused)))
{
  *length=buff->hostname_length;
  return (byte*) buff->host.hostname;
}

static void acl_update_user(const char *user, const char *host,
635 636 637 638 639
			    const char *password, 
			    enum SSL_type ssl_type,
			    const char *ssl_cipher,
			    const char *x509_issuer,
			    const char *x509_subject,
640
			    USER_RESOURCES  *mqh, 
641
			    ulong privileges)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
642 643 644 645 646 647 648 649 650
{
  for (uint i=0 ; i < acl_users.elements ; i++)
  {
    ACL_USER *acl_user=dynamic_element(&acl_users,i,ACL_USER*);
    if (!acl_user->user && !user[0] ||
	acl_user->user &&
	!strcmp(user,acl_user->user))
    {
      if (!acl_user->host.hostname && !host[0] ||
651
	  acl_user->host.hostname &&
652
	  !my_strcasecmp(system_charset_info, host, acl_user->host.hostname))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
653 654
      {
	acl_user->access=privileges;
655
	if (mqh->bits & 1)
656
	  acl_user->user_resource.questions=mqh->questions;
657
	if (mqh->bits & 2)
658
	  acl_user->user_resource.updates=mqh->updates;
659
	if (mqh->bits & 4)
660
	  acl_user->user_resource.connections=mqh->connections;
661 662 663 664 665 666 667 668 669 670
	if (ssl_type != SSL_TYPE_NOT_SPECIFIED)
	{
	  acl_user->ssl_type= ssl_type;
	  acl_user->ssl_cipher= (ssl_cipher ? strdup_root(&mem,ssl_cipher) :
				 0);
	  acl_user->x509_issuer= (x509_issuer ? strdup_root(&mem,x509_issuer) :
				  0);
	  acl_user->x509_subject= (x509_subject ?
				   strdup_root(&mem,x509_subject) : 0);
	}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688
	if (password)
	{
	  if (!password[0])
	    acl_user->password=0;
	  else
	  {
	    acl_user->password=(char*) "";	// Just point at something
	    get_salt_from_password(acl_user->salt,password);
	  }
	}
	break;
      }
    }
  }
}


static void acl_insert_user(const char *user, const char *host,
689 690 691 692 693
			    const char *password, 
			    enum SSL_type ssl_type,
			    const char *ssl_cipher,
			    const char *x509_issuer,
			    const char *x509_subject,
694
			    USER_RESOURCES *mqh,
695
			    ulong privileges)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
696 697 698 699 700 701
{
  ACL_USER acl_user;
  acl_user.user=strdup_root(&mem,user);
  update_hostname(&acl_user.host,strdup_root(&mem,host));
  acl_user.password=0;
  acl_user.access=privileges;
702
  acl_user.user_resource = *mqh;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
703
  acl_user.sort=get_sort(2,acl_user.host.hostname,acl_user.user);
704
  acl_user.hostname_length=(uint) strlen(acl_user.host.hostname);
705 706 707 708 709
  acl_user.ssl_type= (ssl_type != SSL_TYPE_NOT_SPECIFIED ?
		      ssl_type : SSL_TYPE_NONE);
  acl_user.ssl_cipher=	ssl_cipher   ? strdup_root(&mem,ssl_cipher) : 0;
  acl_user.x509_issuer= x509_issuer  ? strdup_root(&mem,x509_issuer) : 0;
  acl_user.x509_subject=x509_subject ? strdup_root(&mem,x509_subject) : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730
  if (password)
  {
    acl_user.password=(char*) "";		// Just point at something
    get_salt_from_password(acl_user.salt,password);
  }

  VOID(push_dynamic(&acl_users,(gptr) &acl_user));
  if (!acl_user.host.hostname || acl_user.host.hostname[0] == wild_many
      && !acl_user.host.hostname[1])
    allow_all_hosts=1;			// Anyone can connect /* purecov: tested */
  qsort((gptr) dynamic_element(&acl_users,0,ACL_USER*),acl_users.elements,
	sizeof(ACL_USER),(qsort_cmp) acl_compare);

  /* We must free acl_check_hosts as its memory is mapped to acl_user */
  delete_dynamic(&acl_wild_hosts);
  hash_free(&acl_check_hosts);
  init_check_host();
}


static void acl_update_db(const char *user, const char *host, const char *db,
731
			  ulong privileges)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
732 733 734 735 736 737 738 739 740
{
  for (uint i=0 ; i < acl_dbs.elements ; i++)
  {
    ACL_DB *acl_db=dynamic_element(&acl_dbs,i,ACL_DB*);
    if (!acl_db->user && !user[0] ||
	acl_db->user &&
	!strcmp(user,acl_db->user))
    {
      if (!acl_db->host.hostname && !host[0] ||
741 742
	  acl_db->host.hostname &&
	  !my_strcasecmp(system_charset_info, host, acl_db->host.hostname))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
743 744 745 746 747 748 749 750 751 752 753 754 755 756 757
      {
	if (!acl_db->db && !db[0] ||
	    acl_db->db && !strcmp(db,acl_db->db))
	{
	  if (privileges)
	    acl_db->access=privileges;
	  else
	    delete_dynamic_element(&acl_dbs,i);
	}
      }
    }
  }
}


758 759 760 761 762 763 764 765 766 767 768 769 770 771
/*
  Insert a user/db/host combination into the global acl_cache

  SYNOPSIS
    acl_insert_db()
    user		User name
    host		Host name
    db			Database name
    privileges		Bitmap of privileges

  NOTES
    acl_cache->lock must be locked when calling this
*/

bk@work.mysql.com's avatar
bk@work.mysql.com committed
772
static void acl_insert_db(const char *user, const char *host, const char *db,
773
			  ulong privileges)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
774 775
{
  ACL_DB acl_db;
776
  safe_mutex_assert_owner(&acl_cache->lock);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
777 778 779 780 781 782 783 784 785 786 787 788 789 790 791
  acl_db.user=strdup_root(&mem,user);
  update_hostname(&acl_db.host,strdup_root(&mem,host));
  acl_db.db=strdup_root(&mem,db);
  acl_db.access=privileges;
  acl_db.sort=get_sort(3,acl_db.host.hostname,acl_db.db,acl_db.user);
  VOID(push_dynamic(&acl_dbs,(gptr) &acl_db));
  qsort((gptr) dynamic_element(&acl_dbs,0,ACL_DB*),acl_dbs.elements,
	sizeof(ACL_DB),(qsort_cmp) acl_compare);
}


/*****************************************************************************
** Get privilege for a host, user and db combination
*****************************************************************************/

792
ulong acl_get(const char *host, const char *ip, const char *bin_ip,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
793 794
	     const char *user, const char *db)
{
795 796
  ulong host_access,db_access;
  uint i,key_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
797
  db_access=0; host_access= ~0;
798
  char key[ACL_KEY_LENGTH],*tmp_db,*end;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
799 800 801 802
  acl_entry *entry;

  VOID(pthread_mutex_lock(&acl_cache->lock));
  memcpy_fixed(&key,bin_ip,sizeof(struct in_addr));
803 804 805
  end=strmov((tmp_db=strmov(key+sizeof(struct in_addr),user)+1),db);
  if (lower_case_table_names)
  {
806
    my_casedn_str(system_charset_info, tmp_db);
807 808
    db=tmp_db;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869
  key_length=(uint) (end-key);
  if ((entry=(acl_entry*) acl_cache->search(key,key_length)))
  {
    db_access=entry->access;
    VOID(pthread_mutex_unlock(&acl_cache->lock));
    return db_access;
  }

  /*
    Check if there are some access rights for database and user
  */
  for (i=0 ; i < acl_dbs.elements ; i++)
  {
    ACL_DB *acl_db=dynamic_element(&acl_dbs,i,ACL_DB*);
    if (!acl_db->user || !strcmp(user,acl_db->user))
    {
      if (compare_hostname(&acl_db->host,host,ip))
      {
	if (!acl_db->db || !wild_compare(db,acl_db->db))
	{
	  db_access=acl_db->access;
	  if (acl_db->host.hostname)
	    goto exit;				// Fully specified. Take it
	  break; /* purecov: tested */
	}
      }
    }
  }
  if (!db_access)
    goto exit;					// Can't be better

  /*
    No host specified for user. Get hostdata from host table
  */
  host_access=0;				// Host must be found
  for (i=0 ; i < acl_hosts.elements ; i++)
  {
    ACL_HOST *acl_host=dynamic_element(&acl_hosts,i,ACL_HOST*);
    if (compare_hostname(&acl_host->host,host,ip))
    {
      if (!acl_host->db || !wild_compare(db,acl_host->db))
      {
	host_access=acl_host->access;		// Fully specified. Take it
	break;
      }
    }
  }
exit:
  /* Save entry in cache for quick retrieval */
  if ((entry= (acl_entry*) malloc(sizeof(acl_entry)+key_length)))
  {
    entry->access=(db_access & host_access);
    entry->length=key_length;
    memcpy((gptr) entry->key,key,key_length);
    acl_cache->add(entry);
  }
  VOID(pthread_mutex_unlock(&acl_cache->lock));
  return (db_access & host_access);
}


870
int wild_case_compare(CHARSET_INFO *cs, const char *str,const char *wildstr)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
871 872 873
{
  reg3 int flag;
  DBUG_ENTER("wild_case_compare");
874
  DBUG_PRINT("enter",("str: '%s'  wildstr: '%s'",str,wildstr));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
875 876 877 878 879 880
  while (*wildstr)
  {
    while (*wildstr && *wildstr != wild_many && *wildstr != wild_one)
    {
      if (*wildstr == wild_prefix && wildstr[1])
	wildstr++;
881 882
      if (my_toupper(cs, *wildstr++) != 
          my_toupper(cs, *str++)) DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
883 884 885 886
    }
    if (! *wildstr ) DBUG_RETURN (*str != 0);
    if (*wildstr++ == wild_one)
    {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
887
      if (! *str++) DBUG_RETURN (1);	/* One char; skip */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
888 889 890 891 892 893 894 895 896 897 898 899
    }
    else
    {						/* Found '*' */
      if (!*wildstr) DBUG_RETURN(0);		/* '*' as last char: OK */
      flag=(*wildstr != wild_many && *wildstr != wild_one);
      do
      {
	if (flag)
	{
	  char cmp;
	  if ((cmp= *wildstr) == wild_prefix && wildstr[1])
	    cmp=wildstr[1];
900 901
	  cmp=my_toupper(cs, cmp);
	  while (*str && my_toupper(cs, *str) != cmp)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
902 903 904
	    str++;
	  if (!*str) DBUG_RETURN (1);
	}
905
	if (wild_case_compare(cs, str,wildstr) == 0) DBUG_RETURN (0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921
      } while (*str++);
      DBUG_RETURN(1);
    }
  }
  DBUG_RETURN (*str != '\0');
}

/*****************************************************************************
** check if there are any possible matching entries for this host
** All host names without wild cards are stored in a hash table,
** entries with wildcards are stored in a dynamic array
*****************************************************************************/

static void init_check_host(void)
{
  DBUG_ENTER("init_check_host");
922
  VOID(my_init_dynamic_array(&acl_wild_hosts,sizeof(struct acl_host_and_ip),
bk@work.mysql.com's avatar
bk@work.mysql.com committed
923
			  acl_users.elements,1));
924
  VOID(hash_init(&acl_check_hosts,system_charset_info,acl_users.elements,0,0,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
925 926 927 928 929 930 931 932 933 934 935 936 937 938 939
		 (hash_get_key) check_get_key,0,HASH_CASE_INSENSITIVE));
  if (!allow_all_hosts)
  {
    for (uint i=0 ; i < acl_users.elements ; i++)
    {
      ACL_USER *acl_user=dynamic_element(&acl_users,i,ACL_USER*);
      if (strchr(acl_user->host.hostname,wild_many) ||
	  strchr(acl_user->host.hostname,wild_one) ||
	  acl_user->host.ip_mask)
      {						// Has wildcard
	uint j;
	for (j=0 ; j < acl_wild_hosts.elements ; j++)
	{					// Check if host already exists
	  acl_host_and_ip *acl=dynamic_element(&acl_wild_hosts,j,
					       acl_host_and_ip *);
940 941
	  if (!my_strcasecmp(system_charset_info,
                             acl_user->host.hostname, acl->hostname))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
942 943 944 945 946 947
	    break;				// already stored
	}
	if (j == acl_wild_hosts.elements)	// If new
	  (void) push_dynamic(&acl_wild_hosts,(char*) &acl_user->host);
      }
      else if (!hash_search(&acl_check_hosts,(byte*) &acl_user->host,
948
			    (uint) strlen(acl_user->host.hostname)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971
      {
	if (hash_insert(&acl_check_hosts,(byte*) acl_user))
	{					// End of memory
	  allow_all_hosts=1;			// Should never happen
	  DBUG_VOID_RETURN;
	}
      }
    }
  }
  freeze_size(&acl_wild_hosts);
  freeze_size(&acl_check_hosts.array);
  DBUG_VOID_RETURN;
}


/* Return true if there is no users that can match the given host */

bool acl_check_host(const char *host, const char *ip)
{
  if (allow_all_hosts)
    return 0;
  VOID(pthread_mutex_lock(&acl_cache->lock));

972 973
  if (host && hash_search(&acl_check_hosts,(byte*) host,(uint) strlen(host)) ||
      ip && hash_search(&acl_check_hosts,(byte*) ip,(uint) strlen(ip)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991
  {
    VOID(pthread_mutex_unlock(&acl_cache->lock));
    return 0;					// Found host
  }
  for (uint i=0 ; i < acl_wild_hosts.elements ; i++)
  {
    acl_host_and_ip *acl=dynamic_element(&acl_wild_hosts,i,acl_host_and_ip*);
    if (compare_hostname(acl, host, ip))
    {
      VOID(pthread_mutex_unlock(&acl_cache->lock));
      return 0;					// Host ok
    }
  }
  VOID(pthread_mutex_unlock(&acl_cache->lock));
  return 1;					// Host is not allowed
}

/*****************************************************************************
992 993
  Change password for the user if it's not an anonymous user
  Note: This should write the error directly to the client!
bk@work.mysql.com's avatar
bk@work.mysql.com committed
994 995
*****************************************************************************/

996 997 998 999 1000 1001 1002 1003
/*
  Check if the user is allowed to change password

  SYNOPSIS:
    check_change_password()
    thd		THD
    host	hostname for the user
    user	user name
monty@hundin.mysql.fi's avatar
merge  
monty@hundin.mysql.fi committed
1004

1005 1006 1007 1008 1009 1010 1011
    RETURN VALUE
    0	OK
    1	ERROR  ; In this case the error is sent to the client.
*/

bool check_change_password(THD *thd, const char *host, const char *user)
{
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1012 1013
  if (!initialized)
  {
1014
    send_error(thd, ER_PASSWORD_NOT_ALLOWED); /* purecov: inspected */
1015
    return(1); /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1016
  }
1017 1018
  if (!thd->slave_thread &&
      (strcmp(thd->user,user) ||
1019
       my_strcasecmp(system_charset_info, host, thd->host_or_ip)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1020 1021
  {
    if (check_access(thd, UPDATE_ACL, "mysql",0,1))
1022
      return(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1023
  }
1024 1025
  if (!thd->slave_thread && !thd->user[0])
  {
1026
    send_error(thd, ER_PASSWORD_ANONYMOUS_USER);
1027
    return(1);
1028
  }
1029 1030 1031 1032
  return(0);
}


1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047
/*
  Change a password for a user

  SYNOPSIS
    change_password()
    thd			Thread handle
    host		Hostname
    user		User name
    new_password	New password for host@user

  RETURN VALUES
    0	ok
    1	ERROR; In this case the error is sent to the client.
*/    

1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063
bool change_password(THD *thd, const char *host, const char *user,
		     char *new_password)
{
  uint length=0;
  DBUG_ENTER("change_password");
  DBUG_PRINT("enter",("host: '%s'  user: '%s'  new_password: '%s'",
		      host,user,new_password));
  DBUG_ASSERT(host != 0);			// Ensured by parent

  if (check_change_password(thd, host, user))
    DBUG_RETURN(1);

  /* password should always be 0 or 16 chars; simple hack to avoid cracking */
  length=(uint) strlen(new_password);
  new_password[length & 16]=0;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1064 1065
  VOID(pthread_mutex_lock(&acl_cache->lock));
  ACL_USER *acl_user;
1066
  if (!(acl_user= find_acl_user(host,user)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1067
  {
1068
    send_error(thd, ER_PASSWORD_NO_MATCH);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1069
    VOID(pthread_mutex_unlock(&acl_cache->lock));
1070
    DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1071 1072 1073
  }
  if (update_user_table(thd,
			acl_user->host.hostname ? acl_user->host.hostname : "",
1074 1075
			acl_user->user ? acl_user->user : "",
			new_password))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1076 1077
  {
    VOID(pthread_mutex_unlock(&acl_cache->lock)); /* purecov: deadcode */
1078
    send_error(thd,0); /* purecov: deadcode */
1079
    DBUG_RETURN(1); /* purecov: deadcode */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1080 1081 1082 1083 1084 1085 1086 1087 1088 1089
  }
  get_salt_from_password(acl_user->salt,new_password);
  if (!new_password[0])
    acl_user->password=0;
  else
    acl_user->password=(char*) "";		// Point at something
  acl_cache->clear(1);				// Clear locked hostname cache
  VOID(pthread_mutex_unlock(&acl_cache->lock));

  char buff[460];
1090
  ulong query_length=
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1091 1092
    my_sprintf(buff,
	       (buff,"SET PASSWORD FOR \"%-.120s\"@\"%-.120s\"=\"%-.120s\"",
1093
		acl_user->user ? acl_user->user : "",
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1094 1095
		acl_user->host.hostname ? acl_user->host.hostname : "",
		new_password));
1096
  mysql_update_log.write(thd, buff, query_length);
1097
  Query_log_event qinfo(thd, buff, query_length, 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1098
  mysql_bin_log.write(&qinfo);
1099
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1100 1101 1102 1103 1104 1105 1106 1107 1108 1109
}


/*
  Find first entry that matches the current user
*/

static ACL_USER *
find_acl_user(const char *host, const char *user)
{
1110
  DBUG_ENTER("find_acl_user");
1111
  DBUG_PRINT("enter",("host: '%s'  user: '%s'",host,user));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1112 1113 1114
  for (uint i=0 ; i < acl_users.elements ; i++)
  {
    ACL_USER *acl_user=dynamic_element(&acl_users,i,ACL_USER*);
1115 1116
    DBUG_PRINT("info",("strcmp('%s','%s'), compare_hostname('%s','%s'),",
			    user,acl_user->user,(host),(acl_user->host)));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1117 1118 1119
    if (!acl_user->user && !user[0] ||
	acl_user->user && !strcmp(user,acl_user->user))
    {
1120 1121 1122 1123
      if (compare_hostname(&(acl_user->host),host,host))
      {
	DBUG_RETURN(acl_user);
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1124 1125
    }
  }
1126
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178
}

/*****************************************************************************
	Handle comparing of hostname
	A hostname may be of type:
	hostname   (May include wildcards);   monty.pp.sci.fi
	ip	   (May include wildcards);   192.168.0.0
	ip/netmask			      192.168.0.0/255.255.255.0

	A net mask of 0.0.0.0 is not allowed.
*****************************************************************************/

static const char *calc_ip(const char *ip, long *val, char end)
{
  long ip_val,tmp;
  if (!(ip=str2int(ip,10,0,255,&ip_val)) || *ip != '.')
    return 0;
  ip_val<<=24;
  if (!(ip=str2int(ip+1,10,0,255,&tmp)) || *ip != '.')
    return 0;
  ip_val+=tmp<<16;
  if (!(ip=str2int(ip+1,10,0,255,&tmp)) || *ip != '.')
    return 0;
  ip_val+=tmp<<8;
  if (!(ip=str2int(ip+1,10,0,255,&tmp)) || *ip != end)
    return 0;
  *val=ip_val+tmp;
  return ip;
}


static void update_hostname(acl_host_and_ip *host, const char *hostname)
{
  host->hostname=(char*) hostname;		// This will not be modified!
  if (hostname &&
      (!(hostname=calc_ip(hostname,&host->ip,'/')) ||
       !(hostname=calc_ip(hostname+1,&host->ip_mask,'\0'))))
  {
    host->ip=host->ip_mask=0;			// Not a masked ip
  }
}


static bool compare_hostname(const acl_host_and_ip *host, const char *hostname,
			     const char *ip)
{
  long tmp;
  if (host->ip_mask && ip && calc_ip(ip,&tmp,'\0'))
  {
    return (tmp & host->ip_mask) == host->ip;
  }
  return (!host->hostname ||
1179 1180
	  (hostname && !wild_case_compare(system_charset_info,
                                          hostname,host->hostname)) ||
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1181 1182 1183 1184 1185
	  (ip && !wild_compare(ip,host->hostname)));
}


/****************************************************************************
1186
  Code to update grants in the user and database privilege tables
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198
****************************************************************************/

static bool update_user_table(THD *thd, const char *host, const char *user,
			      const char *new_password)
{
  TABLE_LIST tables;
  TABLE *table;
  bool error=1;
  DBUG_ENTER("update_user_table");
  DBUG_PRINT("enter",("user: %s  host: %s",user,host));

  bzero((char*) &tables,sizeof(tables));
1199
  tables.alias=tables.real_name=(char*) "user";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1200 1201 1202
  tables.db=(char*) "mysql";
  if (!(table=open_ltable(thd,&tables,TL_WRITE)))
    DBUG_RETURN(1); /* purecov: deadcode */
1203 1204
  table->field[0]->store(host,(uint) strlen(host), system_charset_info);
  table->field[1]->store(user,(uint) strlen(user), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1205 1206 1207 1208 1209 1210 1211 1212 1213

  if (table->file->index_read_idx(table->record[0],0,
				  (byte*) table->field[0]->ptr,0,
				  HA_READ_KEY_EXACT))
  {
    my_error(ER_PASSWORD_NO_MATCH,MYF(0));	/* purecov: deadcode */
    DBUG_RETURN(1);				/* purecov: deadcode */
  }
  store_record(table,1);
1214
  table->field[2]->store(new_password,(uint) strlen(new_password), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226
  if ((error=table->file->update_row(table->record[1],table->record[0])))
  {
    table->file->print_error(error,MYF(0));	/* purecov: deadcode */
    goto end;					/* purecov: deadcode */
  }
  error=0;					// Record updated

end:
  close_thread_tables(thd);
  DBUG_RETURN(error);
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1227 1228 1229 1230 1231 1232 1233 1234 1235

/* Return 1 if we are allowed to create new users */

static bool test_if_create_new_users(THD *thd)
{
  bool create_new_users=1;    // Assume that we are allowed to create new users
  if (opt_safe_user_create && !(thd->master_access & INSERT_ACL))
  {
    TABLE_LIST tl;
1236
    ulong db_access;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1237 1238
    bzero((char*) &tl,sizeof(tl));
    tl.db=	   (char*) "mysql";
1239
    tl.real_name=  (char*) "user";
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251
    db_access=acl_get(thd->host, thd->ip, (char*) &thd->remote.sin_addr,
		      thd->priv_user, tl.db);
    if (!(db_access & INSERT_ACL))
    {
      if (check_grant(thd,INSERT_ACL,&tl,0,1))
	create_new_users=0;
    }
  }
  return create_new_users;
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1252 1253 1254 1255
/****************************************************************************
** Handle GRANT commands
****************************************************************************/

1256
static int replace_user_table(THD *thd, TABLE *table, const LEX_USER &combo,
1257 1258
			      ulong rights, bool revoke_grant,
			      bool create_user)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1259 1260
{
  int error = -1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1261
  bool old_row_exists=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1262
  char *password,empty_string[1];
1263
  char what= (revoke_grant) ? 'N' : 'Y';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1264
  DBUG_ENTER("replace_user_table");
1265
  safe_mutex_assert_owner(&acl_cache->lock);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1266

1267 1268
  password=empty_string;
  empty_string[0]=0;
1269

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1270
  if (combo.password.str && combo.password.str[0])
1271
  {
1272
    if (combo.password.length != HASH_PASSWORD_LENGTH)
1273
    {
1274 1275
      my_error(ER_PASSWORD_NO_MATCH,MYF(0));
      DBUG_RETURN(-1);
1276
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1277
    password=combo.password.str;
1278
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1279

1280 1281
  table->field[0]->store(combo.host.str,combo.host.length, system_charset_info);
  table->field[1]->store(combo.user.str,combo.user.length, system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1282 1283 1284 1285 1286
  table->file->index_init(0);
  if (table->file->index_read(table->record[0],
			      (byte*) table->field[0]->ptr,0,
			      HA_READ_KEY_EXACT))
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1287
    if (!create_user)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1288
    {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1289 1290 1291 1292
      if (what == 'N')
	my_printf_error(ER_NONEXISTING_GRANT,ER(ER_NONEXISTING_GRANT),
			MYF(0),combo.user.str,combo.host.str);
      else
1293 1294
	my_printf_error(ER_NO_PERMISSION_TO_CREATE_USER,
			ER(ER_NO_PERMISSION_TO_CREATE_USER),
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1295
			MYF(0),thd->user,
1296
			thd->host_or_ip);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1297 1298 1299
      error= -1;
      goto end;
    }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1300
    old_row_exists = 0;
1301 1302 1303 1304
    restore_record(table,2);	// cp empty row from record[2]
    table->field[0]->store(combo.host.str,combo.host.length, system_charset_info);
    table->field[1]->store(combo.user.str,combo.user.length, system_charset_info);
    table->field[2]->store(password,(uint) strlen(password), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1305 1306 1307
  }
  else
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1308
    old_row_exists = 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1309 1310
    store_record(table,1);			// Save copy for update
    if (combo.password.str)			// If password given
1311
      table->field[2]->store(password,(uint) strlen(password), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1312 1313
  }

1314 1315 1316 1317 1318 1319 1320 1321
  /* Update table columns with new privileges */

  Field **tmp_field;
  ulong priv;
  for (tmp_field= table->field+3, priv = SELECT_ACL;
       *tmp_field && (*tmp_field)->real_type() == FIELD_TYPE_ENUM &&
	 ((Field_enum*) (*tmp_field))->typelib->count == 2 ;
       tmp_field++, priv <<= 1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1322
  {
1323
    if (priv & rights)				 // set requested privileges
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1324
      (*tmp_field)->store(&what, 1, system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1325 1326
  }
  rights=get_access(table,3);
1327
  DBUG_PRINT("info",("table->fields: %d",table->fields));
1328
  if (table->fields >= 31)		/* From 4.0.0 we have more fields */
1329
  {
1330
    /* We write down SSL related ACL stuff */
1331 1332
    switch (thd->lex.ssl_type) {
    case SSL_TYPE_ANY:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1333
      table->field[24]->store("ANY",3, system_charset_info);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1334 1335 1336
      table->field[25]->store("", 0, system_charset_info);
      table->field[26]->store("", 0, system_charset_info);
      table->field[27]->store("", 0, system_charset_info);
1337 1338
      break;
    case SSL_TYPE_X509:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1339
      table->field[24]->store("X509",4, system_charset_info);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1340 1341 1342
      table->field[25]->store("", 0, system_charset_info);
      table->field[26]->store("", 0, system_charset_info);
      table->field[27]->store("", 0, system_charset_info);
1343 1344
      break;
    case SSL_TYPE_SPECIFIED:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1345
      table->field[24]->store("SPECIFIED",9, system_charset_info);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1346 1347 1348
      table->field[25]->store("", 0, system_charset_info);
      table->field[26]->store("", 0, system_charset_info);
      table->field[27]->store("", 0, system_charset_info);
1349
      if (thd->lex.ssl_cipher)
1350
	table->field[25]->store(thd->lex.ssl_cipher,
1351
				strlen(thd->lex.ssl_cipher), system_charset_info);
1352
      if (thd->lex.x509_issuer)
1353
	table->field[26]->store(thd->lex.x509_issuer,
1354
				strlen(thd->lex.x509_issuer), system_charset_info);
1355
      if (thd->lex.x509_subject)
1356
	table->field[27]->store(thd->lex.x509_subject,
1357
				strlen(thd->lex.x509_subject), system_charset_info);
1358
      break;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1359
    case SSL_TYPE_NOT_SPECIFIED:
gluh@gluh.(none)'s avatar
gluh@gluh.(none) committed
1360 1361
      break;
    case SSL_TYPE_NONE:
1362 1363 1364 1365
      table->field[24]->store("", 0, system_charset_info);
      table->field[25]->store("", 0, system_charset_info);
      table->field[26]->store("", 0, system_charset_info);
      table->field[27]->store("", 0, system_charset_info);
gluh@gluh.(none)'s avatar
gluh@gluh.(none) committed
1366
      break;
1367
    }
1368

1369
    USER_RESOURCES mqh = thd->lex.mqh;
1370
    if (mqh.bits & 1)
1371
      table->field[28]->store((longlong) mqh.questions);
1372
    if (mqh.bits & 2)
1373
      table->field[29]->store((longlong) mqh.updates);
1374
    if (mqh.bits & 4)
1375
      table->field[30]->store((longlong) mqh.connections);
1376
    mqh_used = mqh_used || mqh.questions || mqh.updates || mqh.connections;
1377
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1378
  if (old_row_exists)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403
  {
    /*
      We should NEVER delete from the user table, as a uses can still
      use mysqld even if he doesn't have any privileges in the user table!
    */
    if (cmp_record(table,1) &&
	(error=table->file->update_row(table->record[1],table->record[0])))
    {						// This should never happen
      table->file->print_error(error,MYF(0));	/* purecov: deadcode */
      error= -1;				/* purecov: deadcode */
      goto end;					/* purecov: deadcode */
    }
  }
  else if ((error=table->file->write_row(table->record[0]))) // insert
  {						// This should never happen
    if (error && error != HA_ERR_FOUND_DUPP_KEY &&
	error != HA_ERR_FOUND_DUPP_UNIQUE)	/* purecov: inspected */
    {
      table->file->print_error(error,MYF(0));	/* purecov: deadcode */
      error= -1;				/* purecov: deadcode */
      goto end;					/* purecov: deadcode */
    }
  }
  error=0;					// Privileges granted / revoked

1404
end:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1405 1406 1407 1408 1409
  if (!error)
  {
    acl_cache->clear(1);			// Clear privilege cache
    if (!combo.password.str)
      password=0;				// No password given on command
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1410
    if (old_row_exists)
1411
      acl_update_user(combo.user.str,combo.host.str,password,
1412 1413 1414 1415
		      thd->lex.ssl_type,
		      thd->lex.ssl_cipher,
		      thd->lex.x509_issuer,
		      thd->lex.x509_subject,
1416
		      &thd->lex.mqh,
1417
		      rights);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1418
    else
1419
      acl_insert_user(combo.user.str,combo.host.str,password,
1420 1421 1422 1423
		      thd->lex.ssl_type,
		      thd->lex.ssl_cipher,
		      thd->lex.x509_issuer,
		      thd->lex.x509_subject,
1424
		      &thd->lex.mqh,
1425
		      rights);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1426 1427 1428 1429 1430 1431 1432
  }
  table->file->index_end();
  DBUG_RETURN(error);
}


/*
1433
  change grants in the mysql.db table
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1434 1435 1436 1437
*/

static int replace_db_table(TABLE *table, const char *db,
			    const LEX_USER &combo,
1438
			    ulong rights, bool revoke_grant)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1439
{
1440 1441
  uint i;
  ulong priv,store_rights;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1442
  bool old_row_exists=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1443
  int error;
1444
  char what= (revoke_grant) ? 'N' : 'Y';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1445 1446 1447 1448 1449 1450 1451 1452 1453
  DBUG_ENTER("replace_db_table");

  // is there such a user in user table in memory ????
  if (!initialized || !find_acl_user(combo.host.str,combo.user.str))
  {
    my_error(ER_PASSWORD_NO_MATCH,MYF(0));
    DBUG_RETURN(-1);
  }

1454 1455 1456
  table->field[0]->store(combo.host.str,combo.host.length, system_charset_info);
  table->field[1]->store(db,(uint) strlen(db), system_charset_info);
  table->field[2]->store(combo.user.str,combo.user.length, system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1457 1458 1459 1460 1461 1462 1463 1464 1465 1466
  table->file->index_init(0);
  if (table->file->index_read(table->record[0],(byte*) table->field[0]->ptr,0,
	      HA_READ_KEY_EXACT))
  {
    if (what == 'N')
    { // no row, no revoke
      my_printf_error(ER_NONEXISTING_GRANT,ER(ER_NONEXISTING_GRANT),MYF(0),
		      combo.user.str,combo.host.str);
      goto abort;
    }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1467
    old_row_exists = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1468
    restore_record(table,2);			// cp empty row from record[2]
1469 1470 1471
    table->field[0]->store(combo.host.str,combo.host.length, system_charset_info);
    table->field[1]->store(db,(uint) strlen(db), system_charset_info);
    table->field[2]->store(combo.user.str,combo.user.length, system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1472 1473 1474
  }
  else
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1475
    old_row_exists = 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1476 1477 1478 1479
    store_record(table,1);
  }

  store_rights=get_rights_for_db(rights);
1480
  for (i= 3, priv= 1; i < table->fields; i++, priv <<= 1)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1481
  {
1482
    if (priv & store_rights)			// do it if priv is chosen
1483
      table->field [i]->store(&what,1, system_charset_info);// set requested privileges
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1484 1485 1486 1487
  }
  rights=get_access(table,3);
  rights=fix_rights_for_db(rights);

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1488
  if (old_row_exists)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1489
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1490
    // update old existing row
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508
    if (rights)
    {
      if ((error=table->file->update_row(table->record[1],table->record[0])))
	goto table_error;			/* purecov: deadcode */
    }
    else	/* must have been a revoke of all privileges */
    {
      if ((error = table->file->delete_row(table->record[1])))
	goto table_error;			/* purecov: deadcode */
    }
  }
  else if ((error=table->file->write_row(table->record[0])))
  {
    if (error && error != HA_ERR_FOUND_DUPP_KEY) /* purecov: inspected */
      goto table_error; /* purecov: deadcode */
  }

  acl_cache->clear(1);				// Clear privilege cache
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1509
  if (old_row_exists)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529
    acl_update_db(combo.user.str,combo.host.str,db,rights);
  else
    acl_insert_db(combo.user.str,combo.host.str,db,rights);
  table->file->index_end();
  DBUG_RETURN(0);

  /* This could only happen if the grant tables got corrupted */
 table_error:
  table->file->print_error(error,MYF(0));	/* purecov: deadcode */
  table->file->index_end();

 abort:
  DBUG_RETURN(-1);
}


class GRANT_COLUMN :public Sql_alloc
{
public:
  char *column;
1530 1531 1532
  ulong rights;
  uint key_length;
  GRANT_COLUMN(String &c,  ulong y) :rights (y)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1533
  {
1534
    column= memdup_root(&memex,c.ptr(), key_length=c.length());
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1535 1536 1537
  }
};

1538

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1539 1540 1541 1542 1543 1544 1545
static byte* get_key_column(GRANT_COLUMN *buff,uint *length,
			    my_bool not_used __attribute__((unused)))
{
  *length=buff->key_length;
  return (byte*) buff->column;
}

1546

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1547 1548 1549 1550
class GRANT_TABLE :public Sql_alloc
{
public:
  char *host,*db,*user,*tname, *hash_key;
1551 1552
  ulong privs, cols;
  uint key_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1553 1554
  HASH hash_columns;
  GRANT_TABLE (const char *h, const char *d,const char *u, const char *t,
1555
	       ulong p, ulong c)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1556 1557 1558 1559 1560 1561
    : privs(p), cols(c)
  {
    host = strdup_root(&memex,h);
    db =   strdup_root(&memex,d);
    user = strdup_root(&memex,u);
    tname= strdup_root(&memex,t);
1562 1563
    if (lower_case_table_names)
    {
1564 1565
      my_casedn_str(system_charset_info, db);
      my_casedn_str(system_charset_info, tname);
1566
    }
1567
    key_length =(uint) strlen(d)+(uint) strlen(u)+(uint) strlen(t)+3;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1568 1569
    hash_key = (char*) alloc_root(&memex,key_length);
    strmov(strmov(strmov(hash_key,user)+1,db)+1,tname);
1570 1571
    (void) hash_init(&hash_columns,system_charset_info,
		     0,0,0, (hash_get_key) get_key_column,0,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1572 1573 1574 1575 1576 1577 1578 1579 1580
		     HASH_CASE_INSENSITIVE);
  }

  GRANT_TABLE (TABLE *form, TABLE *col_privs)
  {
    byte key[MAX_KEY_LENGTH];

    host =  get_field(&memex,form,0);
    db =    get_field(&memex,form,1);
1581 1582 1583
    user =  get_field(&memex,form,2);
    if (!user)
      user=(char*) "";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1584 1585 1586 1587 1588 1589 1590
    tname = get_field(&memex,form,3);
    if (!host || !db || !tname)
    {
      /* Wrong table row; Ignore it */
      privs = cols = 0;				/* purecov: inspected */
      return;					/* purecov: inspected */
    }
1591 1592
    if (lower_case_table_names)
    {
1593 1594
      my_casedn_str(system_charset_info, db);
      my_casedn_str(system_charset_info, tname);
1595 1596 1597
    }
    key_length = ((uint) strlen(db) + (uint) strlen(user) +
		  (uint) strlen(tname) + 3);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1598 1599
    hash_key = (char*) alloc_root(&memex,key_length);
    strmov(strmov(strmov(hash_key,user)+1,db)+1,tname);
1600 1601
    privs = (ulong) form->field[6]->val_int();
    cols  = (ulong) form->field[7]->val_int();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1602 1603 1604
    privs = fix_rights_for_table(privs);
    cols =  fix_rights_for_column(cols);

1605 1606
    (void) hash_init(&hash_columns,system_charset_info,
		     0,0,0, (hash_get_key) get_key_column,0,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1607 1608 1609 1610
		     HASH_CASE_INSENSITIVE);
    if (cols)
    {
      int key_len;
1611 1612 1613 1614
      col_privs->field[0]->store(host,(uint) strlen(host), system_charset_info);
      col_privs->field[1]->store(db,(uint) strlen(db), system_charset_info);
      col_privs->field[2]->store(user,(uint) strlen(user), system_charset_info);
      col_privs->field[3]->store(tname,(uint) strlen(tname), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1615 1616 1617 1618 1619
      key_len=(col_privs->field[0]->pack_length()+
	       col_privs->field[1]->pack_length()+
	       col_privs->field[2]->pack_length()+
	       col_privs->field[3]->pack_length());
      key_copy(key,col_privs,0,key_len);
1620
      col_privs->field[4]->store("",0, system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634
      col_privs->file->index_init(0);
      if (col_privs->file->index_read(col_privs->record[0],
				      (byte*) col_privs->field[0]->ptr,
				      key_len, HA_READ_KEY_EXACT))
      {
	cols = 0; /* purecov: deadcode */
	return;
      }
      do
      {
	String *res,column_name;
	GRANT_COLUMN *mem_check;
	/* As column name is a string, we don't have to supply a buffer */
	res=col_privs->field[4]->val_str(&column_name,&column_name);
1635
	ulong priv= (ulong) col_privs->field[6]->val_int();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650
	if (!(mem_check = new GRANT_COLUMN(*res,
					   fix_rights_for_column(priv))))
	{
	  // Don't use this entry
	  privs = cols = 0;			/* purecov: deadcode */
	  return;				/* purecov: deadcode */
	}
	hash_insert(&hash_columns, (byte *) mem_check);
      } while (!col_privs->file->index_next(col_privs->record[0]) &&
	       !key_cmp(col_privs,key,0,key_len));
    }
  }
  bool ok() { return privs != 0 || cols != 0; }
};

1651

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1652 1653 1654 1655 1656 1657 1658
static byte* get_grant_table(GRANT_TABLE *buff,uint *length,
			     my_bool not_used __attribute__((unused)))
{
  *length=buff->key_length;
  return (byte*) buff->hash_key;
}

1659

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1660 1661 1662 1663 1664
void free_grant_table(GRANT_TABLE *grant_table)
{
  hash_free(&grant_table->hash_columns);
}

1665

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684
/* Search after a matching grant. Prefer exact grants before not exact ones */

static GRANT_TABLE *table_hash_search(const char *host,const char* ip,
				      const char *db,
				      const char *user, const char *tname,
				      bool exact)
{
  char helping [NAME_LEN*2+USERNAME_LENGTH+3];
  uint len;
  GRANT_TABLE *grant_table,*found=0;

  len  = (uint) (strmov(strmov(strmov(helping,user)+1,db)+1,tname)-helping)+ 1;
  for (grant_table=(GRANT_TABLE*) hash_search(&hash_tables,(byte*) helping,
					      len) ;
       grant_table ;
       grant_table= (GRANT_TABLE*) hash_next(&hash_tables,(byte*) helping,len))
  {
    if (exact)
    {
1685 1686
      if ((host &&
	   !my_strcasecmp(system_charset_info, host, grant_table->host)) ||
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1687 1688 1689 1690 1691
	  (ip && !strcmp(ip,grant_table->host)))
	return grant_table;
    }
    else
    {
1692 1693 1694 1695
      if ((host && !wild_case_compare(system_charset_info, 
                                      host,grant_table->host)) ||
	  (ip && !wild_case_compare(system_charset_info, 
                                    ip,grant_table->host)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1696 1697 1698 1699 1700 1701 1702 1703
	found=grant_table;					// Host ok
    }
  }
  return found;
}



1704
inline GRANT_COLUMN *
1705
column_hash_search(GRANT_TABLE *t, const char *cname, uint length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1706 1707 1708 1709 1710 1711 1712 1713 1714
{
  return (GRANT_COLUMN*) hash_search(&t->hash_columns, (byte*) cname,length);
}


static int replace_column_table(GRANT_TABLE *g_t,
				TABLE *table, const LEX_USER &combo,
				List <LEX_COLUMN> &columns,
				const char *db, const char *table_name,
1715
				ulong rights, bool revoke_grant)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1716 1717 1718 1719 1720 1721
{
  int error=0,result=0;
  uint key_length;
  byte key[MAX_KEY_LENGTH];
  DBUG_ENTER("replace_column_table");

1722 1723 1724 1725
  table->field[0]->store(combo.host.str,combo.host.length, system_charset_info);
  table->field[1]->store(db,(uint) strlen(db), system_charset_info);
  table->field[2]->store(combo.user.str,combo.user.length, system_charset_info);
  table->field[3]->store(table_name,(uint) strlen(table_name), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738
  key_length=(table->field[0]->pack_length()+ table->field[1]->pack_length()+
	      table->field[2]->pack_length()+ table->field[3]->pack_length());
  key_copy(key,table,0,key_length);

  rights &= COL_ACLS;				// Only ACL for columns

  /* first fix privileges for all columns in column list */

  List_iterator <LEX_COLUMN> iter(columns);
  class LEX_COLUMN *xx;
  table->file->index_init(0);
  while ((xx=iter++))
  {
1739
    ulong privileges = xx->rights;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1740
    bool old_row_exists=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1741
    key_restore(table,key,0,key_length);
1742
    table->field[4]->store(xx->column.ptr(),xx->column.length(),system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754

    if (table->file->index_read(table->record[0],(byte*) table->field[0]->ptr,
				0, HA_READ_KEY_EXACT))
    {
      if (revoke_grant)
      {
	my_printf_error(ER_NONEXISTING_TABLE_GRANT,
			ER(ER_NONEXISTING_TABLE_GRANT),MYF(0),
			combo.user.str, combo.host.str,table_name); /* purecov: inspected */
	result= -1; /* purecov: inspected */
	continue; /* purecov: inspected */
      }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1755
      old_row_exists = 0;
1756
      restore_record(table,2);				// Get empty record
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1757
      key_restore(table,key,0,key_length);
1758
      table->field[4]->store(xx->column.ptr(),xx->column.length(), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1759 1760 1761
    }
    else
    {
1762
      ulong tmp= (ulong) table->field[6]->val_int();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1763 1764 1765 1766 1767 1768
      tmp=fix_rights_for_column(tmp);

      if (revoke_grant)
	privileges = tmp & ~(privileges | rights);
      else
	privileges |= tmp;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1769
      old_row_exists = 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1770 1771 1772 1773 1774
      store_record(table,1);			// copy original row
    }

    table->field[6]->store((longlong) get_rights_for_column(privileges));

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1775
    if (old_row_exists)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821
    {
      if (privileges)
	error=table->file->update_row(table->record[1],table->record[0]);
      else
	error=table->file->delete_row(table->record[1]);
      if (error)
      {
	table->file->print_error(error,MYF(0)); /* purecov: inspected */
	result= -1;				/* purecov: inspected */
	goto end;				/* purecov: inspected */
      }
      GRANT_COLUMN *grant_column = column_hash_search(g_t,
						      xx->column.ptr(),
						      xx->column.length());
      if (grant_column)				// Should always be true
	grant_column->rights = privileges;	// Update hash
    }
    else					// new grant
    {
      if ((error=table->file->write_row(table->record[0])))
      {
	table->file->print_error(error,MYF(0)); /* purecov: inspected */
	result= -1;				/* purecov: inspected */
	goto end;				/* purecov: inspected */
      }
      GRANT_COLUMN *grant_column = new GRANT_COLUMN(xx->column,privileges);
      hash_insert(&g_t->hash_columns,(byte*) grant_column);
    }
  }
  table->file->index_end();

  /*
    If revoke of privileges on the table level, remove all such privileges
    for all columns
  */

  if (revoke_grant)
  {
    table->file->index_init(0);
    if (table->file->index_read(table->record[0], (byte*) table->field[0]->ptr,
				key_length, HA_READ_KEY_EXACT))
      goto end;

    // Scan trough all rows with the same host,db,user and table
    do
    {
1822
      ulong privileges = (ulong) table->field[6]->val_int();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1823 1824 1825 1826 1827 1828 1829
      privileges=fix_rights_for_column(privileges);
      store_record(table,1);

      if (privileges & rights)	// is in this record the priv to be revoked ??
      {
	GRANT_COLUMN *grant_column = NULL;
	char  colum_name_buf[HOSTNAME_LENGTH+1];
1830
	String column_name(colum_name_buf,sizeof(colum_name_buf),system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877

	privileges&= ~rights;
	table->field[6]->store((longlong)
			       get_rights_for_column(privileges));
	table->field[4]->val_str(&column_name,&column_name);
	grant_column = column_hash_search(g_t,
					  column_name.ptr(),
					  column_name.length());
	if (privileges)
	{
	  int tmp_error;
	  if ((tmp_error=table->file->update_row(table->record[1],
						 table->record[0])))
	  {					/* purecov: deadcode */
	    table->file->print_error(tmp_error,MYF(0)); /* purecov: deadcode */
	    result= -1;				/* purecov: deadcode */
	    goto end;				/* purecov: deadcode */
	  }
	  if (grant_column)
	    grant_column->rights  = privileges; // Update hash
	}
	else
	{
	  int tmp_error;
	  if ((tmp_error = table->file->delete_row(table->record[1])))
	  {					/* purecov: deadcode */
	    table->file->print_error(tmp_error,MYF(0)); /* purecov: deadcode */
	    result= -1;				/* purecov: deadcode */
	    goto end;				/* purecov: deadcode */
	  }
	  if (grant_column)
	    hash_delete(&g_t->hash_columns,(byte*) grant_column);
	}
      }
    } while (!table->file->index_next(table->record[0]) &&
	     !key_cmp(table,key,0,key_length));
  }

 end:
  table->file->index_end();
  DBUG_RETURN(result);
}


static int replace_table_table(THD *thd, GRANT_TABLE *grant_table,
			       TABLE *table, const LEX_USER &combo,
			       const char *db, const char *table_name,
1878 1879
			       ulong rights, ulong col_rights,
			       bool revoke_grant)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1880 1881
{
  char grantor[HOSTNAME_LENGTH+1+USERNAME_LENGTH];
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1882
  int old_row_exists = 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1883
  int error=0;
1884
  ulong store_table_rights, store_col_rights;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1885 1886
  DBUG_ENTER("replace_table_table");

1887
  strxmov(grantor, thd->user, "@", thd->host_or_ip, NullS);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1888

1889 1890 1891 1892
  /*
    The following should always succeed as new users are created before
    this function is called!
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1893 1894 1895 1896 1897 1898 1899
  if (!find_acl_user(combo.host.str,combo.user.str))
  {
    my_error(ER_PASSWORD_NO_MATCH,MYF(0));	/* purecov: deadcode */
    DBUG_RETURN(-1);				/* purecov: deadcode */
  }

  restore_record(table,2);			// Get empty record
1900 1901 1902 1903
  table->field[0]->store(combo.host.str,combo.host.length, system_charset_info);
  table->field[1]->store(db,(uint) strlen(db), system_charset_info);
  table->field[2]->store(combo.user.str,combo.user.length, system_charset_info);
  table->field[3]->store(table_name,(uint) strlen(table_name), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922
  store_record(table,1);			// store at pos 1

  if (table->file->index_read_idx(table->record[0],0,
				  (byte*) table->field[0]->ptr,0,
				  HA_READ_KEY_EXACT))
  {
    /*
      The following should never happen as we first check the in memory
      grant tables for the user.  There is however always a small change that
      the user has modified the grant tables directly.
    */
    if (revoke_grant)
    { // no row, no revoke
      my_printf_error(ER_NONEXISTING_TABLE_GRANT,
		      ER(ER_NONEXISTING_TABLE_GRANT),MYF(0),
		      combo.user.str,combo.host.str,
		      table_name);		/* purecov: deadcode */
      DBUG_RETURN(-1);				/* purecov: deadcode */
    }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1923
    old_row_exists = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1924 1925 1926
    restore_record(table,1);			// Get saved record
  }

1927 1928
  store_table_rights= get_rights_for_table(rights);
  store_col_rights=   get_rights_for_column(col_rights);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1929
  if (old_row_exists)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1930
  {
1931
    ulong j,k;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1932
    store_record(table,1);
1933 1934
    j = (ulong) table->field[6]->val_int();
    k = (ulong) table->field[7]->val_int();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1935 1936 1937 1938 1939 1940 1941 1942

    if (revoke_grant)
    {
      // column rights are already fixed in mysql_table_grant !
      store_table_rights=j & ~store_table_rights;
    }
    else
    {
1943 1944
      store_table_rights|= j;
      store_col_rights|=   k;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1945 1946 1947
    }
  }

1948
  table->field[4]->store(grantor,(uint) strlen(grantor), system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1949 1950 1951
  table->field[6]->store((longlong) store_table_rights);
  table->field[7]->store((longlong) store_col_rights);
  rights=fix_rights_for_table(store_table_rights);
1952
  col_rights=fix_rights_for_column(store_col_rights);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1953

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1954
  if (old_row_exists)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970
  {
    if (store_table_rights || store_col_rights)
    {
      if ((error=table->file->update_row(table->record[1],table->record[0])))
	goto table_error;			/* purecov: deadcode */
    }
    else if ((error = table->file->delete_row(table->record[1])))
      goto table_error;				/* purecov: deadcode */
  }
  else
  {
    error=table->file->write_row(table->record[0]);
    if (error && error != HA_ERR_FOUND_DUPP_KEY)
      goto table_error;				/* purecov: deadcode */
  }

1971
  if (rights | col_rights)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1972
  {
1973 1974
    grant_table->privs= rights;
    grant_table->cols=  col_rights;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990
  }
  else
  {
    hash_delete(&hash_tables,(byte*) grant_table);
  }
  DBUG_RETURN(0);

 /* This should never happen */
 table_error:
  table->file->print_error(error,MYF(0)); /* purecov: deadcode */
  DBUG_RETURN(-1); /* purecov: deadcode */
}


int mysql_table_grant (THD *thd, TABLE_LIST *table_list,
		       List <LEX_USER> &user_list,
1991
		       List <LEX_COLUMN> &columns, ulong rights,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1992 1993
		       bool revoke_grant)
{
1994
  ulong column_priv = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1995 1996 1997
  List_iterator <LEX_USER> str_list (user_list);
  LEX_USER *Str;
  TABLE_LIST tables[3];
1998
  bool create_new_users=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1999 2000 2001 2002
  DBUG_ENTER("mysql_table_grant");

  if (!initialized)
  {
2003
    send_error(thd, ER_UNKNOWN_COM_ERROR);	/* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
    return 1;					/* purecov: inspected */
  }
  if (rights & ~TABLE_ACLS)
  {
    my_error(ER_ILLEGAL_GRANT_FOR_TABLE,MYF(0));
    DBUG_RETURN(-1);
  }

  if (columns.elements && !revoke_grant)
  {
    TABLE *table;
    class LEX_COLUMN *check;
    List_iterator <LEX_COLUMN> iter(columns);

    if (!(table=open_ltable(thd,table_list,TL_READ)))
      DBUG_RETURN(-1);
    while ((check = iter++))
    {
      if (!find_field_in_table(thd,table,check->column.ptr(),
			       check->column.length(),0,0))
      {
	my_printf_error(ER_BAD_FIELD_ERROR,ER(ER_BAD_FIELD_ERROR),MYF(0),
2026
			check->column.c_ptr(), table_list->alias);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2027 2028 2029 2030 2031 2032 2033 2034 2035
	DBUG_RETURN(-1);
      }
      column_priv |= check->rights | (rights & COL_ACLS);
    }
    close_thread_tables(thd);
  }
  else if (!(rights & CREATE_ACL) && !revoke_grant)
  {
    char buf[FN_REFLEN];
2036 2037
    sprintf(buf,"%s/%s/%s.frm",mysql_data_home, table_list->db,
	    table_list->real_name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2038 2039 2040
    fn_format(buf,buf,"","",4+16+32);
    if (access(buf,F_OK))
    {
2041
      my_error(ER_NO_SUCH_TABLE,MYF(0),table_list->db, table_list->alias);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2042 2043 2044 2045 2046 2047 2048
      DBUG_RETURN(-1);
    }
  }

  /* open the mysql.tables_priv and mysql.columns_priv tables */

  bzero((char*) &tables,sizeof(tables));
2049 2050 2051
  tables[0].alias=tables[0].real_name= (char*) "user";
  tables[1].alias=tables[1].real_name= (char*) "tables_priv";
  tables[2].alias=tables[2].real_name= (char*) "columns_priv";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065
  tables[0].next=tables+1;
  /* Don't open column table if we don't need it ! */
  tables[1].next=((column_priv ||
		   (revoke_grant && ((rights & COL_ACLS) || columns.elements)))
		  ? tables+2 : 0);
  tables[0].lock_type=tables[1].lock_type=tables[2].lock_type=TL_WRITE;
  tables[0].db=tables[1].db=tables[2].db=(char*) "mysql";

  if (open_and_lock_tables(thd,tables))
  {						// Should never happen
    close_thread_tables(thd);			/* purecov: deadcode */
    DBUG_RETURN(-1);				/* purecov: deadcode */
  }

2066 2067
  if (!revoke_grant)
    create_new_users= test_if_create_new_users(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2068
  int result=0;
2069
  rw_wrlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2070 2071 2072 2073 2074
  MEM_ROOT *old_root=my_pthread_getspecific_ptr(MEM_ROOT*,THR_MALLOC);
  my_pthread_setspecific_ptr(THR_MALLOC,&memex);

  while ((Str = str_list++))
  {
2075
    int error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089
    GRANT_TABLE *grant_table;
    if (!Str->host.str)
    {
      Str->host.str=(char*) "%";
      Str->host.length=1;
    }
    if (Str->host.length > HOSTNAME_LENGTH ||
	Str->user.length > USERNAME_LENGTH)
    {
      my_error(ER_GRANT_WRONG_HOST_OR_USER,MYF(0));
      result= -1;
      continue;
    }
    /* Create user if needed */
2090
    pthread_mutex_lock(&acl_cache->lock);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2091 2092
    error=replace_user_table(thd, tables[0].table, *Str,
			     0, revoke_grant, create_new_users);
2093 2094
    pthread_mutex_unlock(&acl_cache->lock);
    if (error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2095 2096 2097 2098 2099 2100 2101 2102
    {
      result= -1;				// Remember error
      continue;					// Add next user
    }

    /* Find/create cached table grant */
    grant_table= table_hash_search(Str->host.str,NullS,table_list->db,
				   Str->user.str,
2103
				   table_list->real_name,1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2104 2105 2106 2107 2108 2109
    if (!grant_table)
    {
      if (revoke_grant)
      {
	my_printf_error(ER_NONEXISTING_TABLE_GRANT,
			ER(ER_NONEXISTING_TABLE_GRANT),MYF(0),
2110
			Str->user.str, Str->host.str, table_list->real_name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2111 2112 2113 2114 2115
	result= -1;
	continue;
      }
      grant_table = new GRANT_TABLE (Str->host.str,table_list->db,
				     Str->user.str,
2116
				     table_list->real_name,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141 2142 2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162
				     rights,
				     column_priv);
      if (!grant_table)				// end of memory
      {
	result= -1;				/* purecov: deadcode */
	continue;				/* purecov: deadcode */
      }
      hash_insert(&hash_tables,(byte*) grant_table);
    }

    /* If revoke_grant, calculate the new column privilege for tables_priv */
    if (revoke_grant)
    {
      class LEX_COLUMN *check;
      List_iterator <LEX_COLUMN> iter(columns);
      GRANT_COLUMN *grant_column;

      /* Fix old grants */
      while ((check = iter++))
      {
	grant_column = column_hash_search(grant_table,
					  check->column.ptr(),
					  check->column.length());
	if (grant_column)
	  grant_column->rights&= ~(check->rights | rights);
      }
      /* scan trough all columns to get new column grant */
      column_priv=0;
      for (uint idx=0 ; idx < grant_table->hash_columns.records ; idx++)
      {
	grant_column= (GRANT_COLUMN*) hash_element(&grant_table->hash_columns,
						   idx);
	grant_column->rights&= ~rights;		// Fix other columns
	column_priv|= grant_column->rights;
      }
    }
    else
    {
      column_priv|= grant_table->cols;
    }


    /* update table and columns */

    if (replace_table_table(thd,grant_table,tables[1].table,*Str,
			    table_list->db,
2163
			    table_list->real_name,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2164 2165 2166 2167 2168 2169 2170 2171 2172
			    rights, column_priv, revoke_grant))
    {						// Crashend table ??
      result= -1;			       /* purecov: deadcode */
    }
    else if (tables[2].table)
    {
      if ((replace_column_table(grant_table,tables[2].table, *Str,
				columns,
				table_list->db,
2173
				table_list->real_name,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2174 2175 2176 2177 2178 2179 2180 2181
				rights, revoke_grant)))
      {
	result= -1;
      }
    }
  }
  grant_option=TRUE;
  my_pthread_setspecific_ptr(THR_MALLOC,old_root);
2182
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2183
  if (!result)
2184
    send_ok(thd);
2185
  /* Tables are automatically closed */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2186 2187 2188 2189
  DBUG_RETURN(result);
}


2190 2191
int mysql_grant (THD *thd, const char *db, List <LEX_USER> &list,
		 ulong rights, bool revoke_grant)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2192 2193 2194
{
  List_iterator <LEX_USER> str_list (list);
  LEX_USER *Str;
2195
  char tmp_db[NAME_LEN+1];
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2196
  bool create_new_users=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2197 2198 2199 2200 2201
  TABLE_LIST tables[2];
  DBUG_ENTER("mysql_grant");

  if (!initialized)
  {
2202 2203
    send_error(thd, ER_UNKNOWN_COM_ERROR);	/* purecov: tested */
    return 1;					/* purecov: tested */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2204 2205
  }

2206 2207 2208
  if (lower_case_table_names && db)
  {
    strmov(tmp_db,db);
2209
    my_casedn_str(system_charset_info, tmp_db);
2210 2211
    db=tmp_db;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2212 2213 2214

  /* open the mysql.user and mysql.db tables */

2215 2216
  tables[0].alias=tables[0].real_name=(char*) "user";
  tables[1].alias=tables[1].real_name=(char*) "db";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227
  tables[0].next=tables+1;
  tables[1].next=0;
  tables[0].lock_type=tables[1].lock_type=TL_WRITE;
  tables[0].db=tables[1].db=(char*) "mysql";
  tables[0].table=tables[1].table=0;
  if (open_and_lock_tables(thd,tables))
  {						// This should never happen
    close_thread_tables(thd);			/* purecov: deadcode */
    DBUG_RETURN(-1);				/* purecov: deadcode */
  }

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2228 2229
  if (!revoke_grant)
    create_new_users= test_if_create_new_users(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2230

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2231
  // go through users in user_list
2232
  rw_wrlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250
  VOID(pthread_mutex_lock(&acl_cache->lock));
  grant_version++;

  int result=0;
  while ((Str = str_list++))
  {
    if (!Str->host.str)
    {
      Str->host.str=(char*) "%";
      Str->host.length=1;
    }
    if (Str->host.length > HOSTNAME_LENGTH ||
	Str->user.length > USERNAME_LENGTH)
    {
      my_error(ER_GRANT_WRONG_HOST_OR_USER,MYF(0));
      result= -1;
      continue;
    }
2251 2252
    if ((replace_user_table(thd,
		            tables[0].table,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2253
			    *Str,
2254 2255
			    (!db ? rights : 0), revoke_grant,
			    create_new_users)))
2256
      result= -1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2257 2258 2259
    else
    {
      if (db && replace_db_table(tables[1].table, db, *Str, rights & DB_ACLS,
2260
				 revoke_grant))
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2261 2262
	result= -1;
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2263 2264
  }
  VOID(pthread_mutex_unlock(&acl_cache->lock));
2265
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2266 2267 2268
  close_thread_tables(thd);

  if (!result)
2269
    send_ok(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2270 2271 2272
  DBUG_RETURN(result);
}

2273 2274

/* Free grant array if possible */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2275 2276 2277 2278 2279 2280

void  grant_free(void)
{
  DBUG_ENTER("grant_free");
  grant_option = FALSE;
  hash_free(&hash_tables);
2281
  free_root(&memex,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2282 2283 2284 2285 2286 2287
  DBUG_VOID_RETURN;
}


/* Init grant array if possible */

2288
my_bool grant_init(THD *org_thd)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2289
{
2290
  THD  *thd;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2291
  TABLE_LIST tables[2];
2292 2293
  MYSQL_LOCK *lock;
  my_bool return_val= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2294 2295 2296 2297
  TABLE *t_table, *c_table;
  DBUG_ENTER("grant_init");

  grant_option = FALSE;
2298 2299
  (void) hash_init(&hash_tables,system_charset_info,
		   0,0,0, (hash_get_key) get_grant_table,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2300
		   (hash_free_key) free_grant_table,0);
2301
  init_sql_alloc(&memex,1024,0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2302

2303
  /* Don't do anything if running with --skip-grant */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2304 2305
  if (!initialized)
    DBUG_RETURN(0);				/* purecov: tested */
2306

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2307 2308
  if (!(thd=new THD))
    DBUG_RETURN(1);				/* purecov: deadcode */
2309
  thd->store_globals();
2310 2311
  thd->db= my_strdup("mysql",MYF(0));
  thd->db_length=5;				// Safety
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2312
  bzero((char*) &tables,sizeof(tables));
2313 2314
  tables[0].alias=tables[0].real_name= (char*) "tables_priv";
  tables[1].alias=tables[1].real_name= (char*) "columns_priv";
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2315 2316 2317 2318 2319
  tables[0].next=tables+1;
  tables[0].lock_type=tables[1].lock_type=TL_READ;
  tables[0].db=tables[1].db=thd->db;

  if (open_tables(thd,tables))
2320 2321
    goto end;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2322 2323 2324
  TABLE *ptr[2];				// Lock tables for quick update
  ptr[0]= tables[0].table;
  ptr[1]= tables[1].table;
2325 2326
  if (!(lock=mysql_lock_tables(thd,ptr,2)))
    goto end;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2327 2328 2329 2330 2331 2332

  t_table = tables[0].table; c_table = tables[1].table;
  t_table->file->index_init(0);
  if (t_table->file->index_first(t_table->record[0]))
  {
    t_table->file->index_end();
2333
    goto end_unlock;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2334
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2335
  grant_option= TRUE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2336 2337
  t_table->file->index_end();

2338
  /* Will be restored by org_thd->store_globals() */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2339
  my_pthread_setspecific_ptr(THR_MALLOC,&memex);
2340
  do
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2341 2342 2343 2344 2345 2346 2347
  {
    GRANT_TABLE *mem_check;
    if (!(mem_check=new GRANT_TABLE(t_table,c_table)) ||
	mem_check->ok() && hash_insert(&hash_tables,(byte*) mem_check))
    {
      /* This could only happen if we are out memory */
      grant_option = FALSE;			/* purecov: deadcode */
2348
      goto end_unlock;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2349 2350
    }
  }
2351 2352 2353 2354 2355
  while (!t_table->file->index_next(t_table->record[0]));

  return_val=0;					// Return ok

end_unlock:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2356 2357
  mysql_unlock_tables(thd, lock);
  thd->version--;				// Force close to free memory
2358 2359

end:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2360 2361
  close_thread_tables(thd);
  delete thd;
2362 2363
  if (org_thd)
    org_thd->store_globals();
2364 2365 2366 2367 2368
  else
  {
    /* Remember that we don't have a THD */
    my_pthread_setspecific_ptr(THR_THD,  0);
  }
2369
  DBUG_RETURN(return_val);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2370 2371 2372 2373 2374
}


/* Reload grant array if possible */

2375
void grant_reload(THD *thd)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2376 2377 2378 2379 2380 2381 2382
{
  HASH old_hash_tables;bool old_grant_option;
  MEM_ROOT old_mem;
  DBUG_ENTER("grant_reload");

  // Locked tables are checked by acl_init and doesn't have to be checked here

2383
  rw_wrlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2384 2385 2386 2387 2388
  grant_version++;
  old_hash_tables=hash_tables;
  old_grant_option = grant_option;
  old_mem = memex;

2389
  if (grant_init(thd))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2390 2391 2392 2393 2394 2395 2396 2397 2398
  {						// Error. Revert to old hash
    grant_free();				/* purecov: deadcode */
    hash_tables=old_hash_tables;		/* purecov: deadcode */
    grant_option = old_grant_option;		/* purecov: deadcode */
    memex = old_mem;				/* purecov: deadcode */
  }
  else
  {
    hash_free(&old_hash_tables);
2399
    free_root(&old_mem,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2400
  }
2401
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2402 2403 2404 2405 2406
  DBUG_VOID_RETURN;
}


/****************************************************************************
2407 2408
  Check grants
  All errors are written directly to the client if command name is given !
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2409 2410
****************************************************************************/

2411
bool check_grant(THD *thd, ulong want_access, TABLE_LIST *tables,
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2412
		 uint show_table, bool no_errors)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2413 2414 2415 2416 2417 2418 2419 2420
{
  TABLE_LIST *table;
  char *user = thd->priv_user;

  want_access &= ~thd->master_access;
  if (!want_access)
    return 0;					// ok

2421
  rw_rdlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2422 2423 2424 2425 2426 2427 2428
  for (table=tables; table ;table=table->next)
  {
    if (!(~table->grant.privilege & want_access))
    {
      table->grant.want_privilege=0;
      continue;					// Already checked
    }
2429 2430
    GRANT_TABLE *grant_table = table_hash_search(thd->host,thd->ip,
						 table->db,user,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2431 2432 2433 2434 2435 2436
						 table->real_name,0);
    if (!grant_table)
    {
      want_access &= ~table->grant.privilege;
      goto err;					// No grants
    }
monty@tramp.mysql.fi's avatar
monty@tramp.mysql.fi committed
2437 2438
    if (show_table)
      continue;					// We have some priv on this
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454

    table->grant.grant_table=grant_table;	// Remember for column test
    table->grant.version=grant_version;
    table->grant.privilege|= grant_table->privs;
    table->grant.want_privilege= ((want_access & COL_ACLS)
				  & ~table->grant.privilege);

    if (!(~table->grant.privilege & want_access))
      continue;

    if (want_access & ~(grant_table->cols | table->grant.privilege))
    {
      want_access &= ~(grant_table->cols | table->grant.privilege);
      goto err;					// impossible
    }
  }
2455
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2456 2457 2458
  return 0;

 err:
2459
  rw_unlock(&LOCK_grant);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2460
  if (!no_errors)				// Not a silent skip of table
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477 2478 2479 2480
  {
    const char *command="";
    if (want_access & SELECT_ACL)
       command ="select";
    else if (want_access & INSERT_ACL)
      command = "insert";
    else if (want_access & UPDATE_ACL)
      command = "update";
    else if (want_access & DELETE_ACL)
      command = "delete";
    else if (want_access & DROP_ACL)
      command = "drop";
    else if (want_access & CREATE_ACL)
      command = "create";
    else if (want_access & ALTER_ACL)
      command = "alter";
    else if (want_access & INDEX_ACL)
      command = "index";
    else if (want_access & GRANT_ACL)
      command = "grant";
2481
    net_printf(thd,ER_TABLEACCESS_DENIED_ERROR,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2482 2483
	       command,
	       thd->priv_user,
2484
	       thd->host_or_ip,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496
	       table ? table->real_name : "unknown");
  }
  return 1;
}


bool check_grant_column (THD *thd,TABLE *table, const char *name,
			 uint length, uint show_tables)
{
  GRANT_TABLE *grant_table;
  GRANT_COLUMN *grant_column;

2497
  ulong want_access=table->grant.want_privilege;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2498 2499 2500
  if (!want_access)
    return 0;					// Already checked

2501
  rw_rdlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518

  // reload table if someone has modified any grants

  if (table->grant.version != grant_version)
  {
    table->grant.grant_table=
      table_hash_search(thd->host,thd->ip,thd->db,
			thd->priv_user,
			table->real_name,0);	/* purecov: inspected */
    table->grant.version=grant_version;		/* purecov: inspected */
  }
  if (!(grant_table=table->grant.grant_table))
    goto err;					/* purecov: deadcode */

  grant_column=column_hash_search(grant_table, name, length);
  if (grant_column && !(~grant_column->rights & want_access))
  {
2519
    rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2520 2521 2522 2523 2524
    return 0;
  }
#ifdef NOT_USED
  if (show_tables && (grant_column || table->grant.privilege & COL_ACLS))
  {
2525
    rw_unlock(&LOCK_grant);			/* purecov: deadcode */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2526 2527 2528 2529 2530 2531
    return 0;					/* purecov: deadcode */
  }
#endif

  /* We must use my_printf_error() here! */
 err:
2532
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2533 2534
  if (!show_tables)
  {
2535 2536
    char command[128];
    get_privilege_desc(command, sizeof(command), want_access);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2537 2538 2539 2540 2541
    my_printf_error(ER_COLUMNACCESS_DENIED_ERROR,
		    ER(ER_COLUMNACCESS_DENIED_ERROR),
		    MYF(0),
		    command,
		    thd->priv_user,
2542
		    thd->host_or_ip,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2543 2544 2545 2546 2547 2548 2549
		    name,
		    table ? table->real_name : "unknown");
  }
  return 1;
}


2550
bool check_grant_all_columns(THD *thd, ulong want_access, TABLE *table)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2551 2552 2553 2554 2555 2556 2557 2558 2559
{
  GRANT_TABLE *grant_table;
  GRANT_COLUMN *grant_column;
  Field *field=0,**ptr;

  want_access &= ~table->grant.privilege;
  if (!want_access)
    return 0;					// Already checked

2560
  rw_rdlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578

  // reload table if someone has modified any grants

  if (table->grant.version != grant_version)
  {
    table->grant.grant_table=
      table_hash_search(thd->host,thd->ip,thd->db,
			thd->priv_user,
			table->real_name,0);	/* purecov: inspected */
    table->grant.version=grant_version;		/* purecov: inspected */
  }
  // The following should always be true
  if (!(grant_table=table->grant.grant_table))
    goto err;					/* purecov: inspected */

  for (ptr=table->field; (field= *ptr) ; ptr++)
  {
    grant_column=column_hash_search(grant_table, field->field_name,
2579
				    (uint) strlen(field->field_name));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2580 2581 2582
    if (!grant_column || (~grant_column->rights & want_access))
      goto err;
  }
2583
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2584 2585 2586 2587
  return 0;

  /* We must use my_printf_error() here! */
 err:
2588
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599

  const char *command="";
  if (want_access & SELECT_ACL)
    command ="select";
  else if (want_access & INSERT_ACL)
    command = "insert";
  my_printf_error(ER_COLUMNACCESS_DENIED_ERROR,
		  ER(ER_COLUMNACCESS_DENIED_ERROR),
		  MYF(0),
		  command,
		  thd->priv_user,
2600
		  thd->host_or_ip,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2601 2602 2603 2604 2605 2606 2607
		  field ? field->field_name : "unknown",
		  table->real_name);
  return 1;
}


/****************************************************************************
2608 2609 2610
  Check if a user has the right to access a database
  Access is accepted if he has a grant for any table in the database
  Return 1 if access is denied
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2611 2612 2613 2614 2615 2616 2617 2618 2619
****************************************************************************/

bool check_grant_db(THD *thd,const char *db)
{
  char helping [NAME_LEN+USERNAME_LENGTH+2];
  uint len;
  bool error=1;

  len  = (uint) (strmov(strmov(helping,thd->priv_user)+1,db)-helping)+ 1;
2620
  rw_rdlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2621 2622 2623 2624 2625 2626

  for (uint idx=0 ; idx < hash_tables.records ; idx++)
  {
    GRANT_TABLE *grant_table = (GRANT_TABLE*) hash_element(&hash_tables,idx);
    if (len < grant_table->key_length &&
	!memcmp(grant_table->hash_key,helping,len) &&
2627 2628 2629 2630
	(thd->host && !wild_case_compare(system_charset_info, 
                                         thd->host,grant_table->host) ||
	 (thd->ip && !wild_case_compare(system_charset_info, 
                                        thd->ip,grant_table->host))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2631 2632 2633 2634 2635
    {
      error=0;					// Found match
      break;
    }
  }
2636
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2637 2638 2639 2640
  return error;
}

/*****************************************************************************
2641
  Functions to retrieve the grant for a table/column  (for SHOW functions)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2642 2643
*****************************************************************************/

2644
ulong get_table_grant(THD *thd, TABLE_LIST *table)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2645
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2646
  ulong privilege;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2647 2648 2649 2650
  char *user = thd->priv_user;
  const char *db = table->db ? table->db : thd->db;
  GRANT_TABLE *grant_table;

2651
  rw_rdlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2652 2653 2654 2655 2656 2657
  grant_table = table_hash_search(thd->host,thd->ip,db,user,
				       table->real_name,0);
  table->grant.grant_table=grant_table; // Remember for column test
  table->grant.version=grant_version;
  if (grant_table)
    table->grant.privilege|= grant_table->privs;
2658
  privilege= table->grant.privilege;
2659
  rw_unlock(&LOCK_grant);
2660
  return privilege;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2661 2662 2663
}


2664
ulong get_column_grant(THD *thd, TABLE_LIST *table, Field *field)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2665 2666 2667
{
  GRANT_TABLE *grant_table;
  GRANT_COLUMN *grant_column;
2668
  ulong priv;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2669

2670
  rw_rdlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685
  // reload table if someone has modified any grants
  if (table->grant.version != grant_version)
  {
    table->grant.grant_table=
      table_hash_search(thd->host,thd->ip,thd->db,
			thd->priv_user,
			table->real_name,0);	/* purecov: inspected */
    table->grant.version=grant_version;		/* purecov: inspected */
  }

  if (!(grant_table=table->grant.grant_table))
    priv=table->grant.privilege;
  else
  {
    grant_column=column_hash_search(grant_table, field->field_name,
2686
				    (uint) strlen(field->field_name));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2687 2688 2689 2690 2691
    if (!grant_column)
      priv=table->grant.privilege;
    else
      priv=table->grant.privilege | grant_column->rights;
  }
2692
  rw_unlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2693 2694 2695 2696 2697
  return priv;
}


/*****************************************************************************
2698 2699
  SHOW GRANTS : send to client grant-like strings depicting user@host
  privileges
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2700 2701 2702
*****************************************************************************/

static const char *command_array[]=
2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713
{
  "SELECT", "INSERT","UPDATE","DELETE","CREATE", "DROP", "RELOAD","SHUTDOWN",
  "PROCESS","FILE","GRANT","REFERENCES","INDEX", "ALTER", "SHOW DATABASES",
  "SUPER", "CREATE TEMPORARY TABLES", "LOCK TABLES", "EXECUTE",
  "REPLICATION SLAVE", "REPLICATION CLIENT",
};
static uint command_lengths[]=
{
  6,6,6,6,6,4,6,8,7,4,5,10,5,5,14,5,23,11,7,17,18
};

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2714 2715 2716

int mysql_show_grants(THD *thd,LEX_USER *lex_user) 
{
2717 2718
  ulong want_access;
  uint counter,index;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2719 2720 2721
  int  error = 0;
  ACL_USER *acl_user; ACL_DB *acl_db;
  char buff[1024];
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
2722
  DBUG_ENTER("mysql_show_grants");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2723 2724 2725 2726

  LINT_INIT(acl_user);
  if (!initialized)
  {
2727
    send_error(thd, ER_UNKNOWN_COM_ERROR);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750
    DBUG_RETURN(-1);
  }
  if (!lex_user->host.str)
  {
    lex_user->host.str=(char*) "%";
    lex_user->host.length=1;
  }
  if (lex_user->host.length > HOSTNAME_LENGTH ||
      lex_user->user.length > USERNAME_LENGTH)
  {
    my_error(ER_GRANT_WRONG_HOST_OR_USER,MYF(0));
    DBUG_RETURN(-1);
  }

  for (counter=0 ; counter < acl_users.elements ; counter++)
  {
    const char *user,*host;
    acl_user=dynamic_element(&acl_users,counter,ACL_USER*);
    if (!(user=acl_user->user))
      user="";
    if (!(host=acl_user->host.hostname))
      host="%";
    if (!strcmp(lex_user->user.str,user) &&
2751
	!my_strcasecmp(system_charset_info, lex_user->host.str, host))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2752 2753 2754 2755 2756 2757 2758 2759 2760
      break;
  }
  if (counter == acl_users.elements) 
  {
    my_printf_error(ER_NONEXISTING_GRANT,ER(ER_NONEXISTING_GRANT),
		    MYF(0),lex_user->user.str,lex_user->host.str);
    DBUG_RETURN(-1);
  }

2761
  Item_string *field=new Item_string("",0,system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2762 2763 2764 2765 2766 2767 2768 2769 2770
  List<Item> field_list;
  field->name=buff;
  field->max_length=1024;
  strxmov(buff,"Grants for ",lex_user->user.str,"@",
	  lex_user->host.str,NullS);
  field_list.push_back(field);
  if (send_fields(thd,field_list,1))
    DBUG_RETURN(-1);

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2771
  rw_wrlock(&LOCK_grant);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2772 2773 2774
  VOID(pthread_mutex_lock(&acl_cache->lock));

  /* Add first global access grants */
2775 2776
  if (acl_user->access || acl_user->password ||
      acl_user->ssl_type != SSL_TYPE_NONE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2777 2778
  {
    want_access=acl_user->access;
2779
    String global(buff,sizeof(buff),system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2780 2781 2782 2783 2784 2785 2786 2787 2788 2789
    global.length(0);
    global.append("GRANT ",6);

    if (test_all_bits(want_access, (GLOBAL_ACLS & ~ GRANT_ACL)))
      global.append("ALL PRIVILEGES",14);
    else if (!(want_access & ~GRANT_ACL))
      global.append("USAGE",5);
    else 
    {
      bool found=0;
2790
      ulong j,test_access= want_access & ~GRANT_ACL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814
      for (counter=0, j = SELECT_ACL;j <= GLOBAL_ACLS;counter++,j <<= 1)
      {
	if (test_access & j) 
	{
	  if (found)
	    global.append(", ",2);
	  found=1;
	  global.append(command_array[counter],command_lengths[counter]);
	}
      }
    }
    global.append (" ON *.* TO '",12);
    global.append(lex_user->user.str,lex_user->user.length); 
    global.append ("'@'",3);
    global.append(lex_user->host.str,lex_user->host.length);
    global.append ('\'');
    if (acl_user->password)
    {
      char passd_buff[HASH_PASSWORD_LENGTH+1];
      make_password_from_salt(passd_buff,acl_user->salt);
      global.append(" IDENTIFIED BY PASSWORD '",25);
      global.append(passd_buff);
      global.append('\'');
    }
2815 2816
    /* "show grants" SSL related stuff */
    if (acl_user->ssl_type == SSL_TYPE_ANY)
2817
      global.append(" REQUIRE SSL",12);
2818
    else if (acl_user->ssl_type == SSL_TYPE_X509)
2819
      global.append(" REQUIRE X509",13);
2820
    else if (acl_user->ssl_type == SSL_TYPE_SPECIFIED)
2821
    {
2822
      int ssl_options = 0;
2823
      global.append(" REQUIRE ",9);
2824 2825
      if (acl_user->x509_issuer)
      {
2826
        ssl_options++;
2827
        global.append("ISSUER \'",8);
2828
        global.append(acl_user->x509_issuer,strlen(acl_user->x509_issuer));
2829
	global.append('\'');
2830
      }
2831 2832 2833
      if (acl_user->x509_subject)
      {
        if (ssl_options++)
2834 2835
          global.append(' ');
        global.append("SUBJECT \'",9);
2836
        global.append(acl_user->x509_subject,strlen(acl_user->x509_subject));
2837
	global.append('\'');
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
2838
      }
2839 2840 2841
      if (acl_user->ssl_cipher)
      {
        if (ssl_options++)
2842
          global.append(' ');
2843
        global.append("CIPHER '",8);
2844
        global.append(acl_user->ssl_cipher,strlen(acl_user->ssl_cipher));
2845
	global.append('\'');
2846 2847
      }
    }
2848 2849 2850
    if ((want_access & GRANT_ACL) ||
	(acl_user->user_resource.questions | acl_user->user_resource.updates |
	 acl_user->user_resource.connections))
2851
    {
2852 2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867 2868 2869 2870 2871 2872 2873 2874 2875
      global.append(" WITH",5); 
      if (want_access & GRANT_ACL)
	global.append(" GRANT OPTION",13); 
      if (acl_user->user_resource.questions)
      {
	char buff[22], *p; // just as in int2str
	global.append(" MAX_QUERIES_PER_HOUR ",22);
	p=int10_to_str(acl_user->user_resource.questions,buff,10);
	global.append(buff,p-buff);
      }
      if (acl_user->user_resource.updates)
      {
	char buff[22], *p; // just as in int2str
	global.append(" MAX_UPDATES_PER_HOUR ",22);
	p=int10_to_str(acl_user->user_resource.updates,buff,10);
	global.append(buff,p-buff);
      }
      if (acl_user->user_resource.connections)
      {
	char buff[22], *p; // just as in int2str
	global.append(" MAX_CONNECTIONS_PER_HOUR ",26);
	p=int10_to_str(acl_user->user_resource.connections,buff,10);
	global.append(buff,p-buff);
      }
2876
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897
    thd->packet.length(0);
    net_store_data(&thd->packet,global.ptr(),global.length());
    if (my_net_write(&thd->net,(char*) thd->packet.ptr(),
		     thd->packet.length()))
    {
      error=-1; goto end;
    }
  }

  /* Add database access */
  for (counter=0 ; counter < acl_dbs.elements ; counter++)
  {
    const char *user,*host;

    acl_db=dynamic_element(&acl_dbs,counter,ACL_DB*);
    if (!(user=acl_db->user))
      user="";
    if (!(host=acl_db->host.hostname))
      host="";

    if (!strcmp(lex_user->user.str,user) &&
2898
	!my_strcasecmp(system_charset_info, lex_user->host.str, host))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2899 2900 2901 2902
    {
      want_access=acl_db->access;
      if (want_access) 
      {
2903
	String db(buff,sizeof(buff),system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2904 2905 2906 2907 2908 2909 2910 2911
	db.length(0);
	db.append("GRANT ",6);

	if (test_all_bits(want_access,(DB_ACLS & ~GRANT_ACL)))
	  db.append("ALL PRIVILEGES",14);
	else
	{
	  int found=0, cnt;
2912
	  ulong j,test_access= want_access & ~GRANT_ACL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923
	  for (cnt=0, j = SELECT_ACL; j <= DB_ACLS; cnt++,j <<= 1)
	  {
	    if (test_access & j)
	    {
	      if (found)
		db.append(", ",2);
	      found = 1;
	      db.append(command_array[cnt],command_lengths[cnt]);
	    }
	  }
	}
2924
	db.append (" ON `",5);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2925
	db.append(acl_db->db);
2926
	db.append ("`.* TO '",8);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2927 2928 2929 2930 2931
	db.append(lex_user->user.str,lex_user->user.length); 
	db.append ("'@'",3);
	db.append(lex_user->host.str, lex_user->host.length);
	db.append ('\'');	
	if (want_access & GRANT_ACL)
2932
	  db.append(" WITH GRANT OPTION",18);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956
	thd->packet.length(0);
	net_store_data(&thd->packet,db.ptr(),db.length());
	if (my_net_write(&thd->net,(char*) thd->packet.ptr(),
			 thd->packet.length()))
	{
	  error=-1;
	  goto end;
	}
      }
    }
  }

  /* Add column access */
  for (index=0 ; index < hash_tables.records ; index++)
  {
    const char *user,*host;
    GRANT_TABLE *grant_table= (GRANT_TABLE*) hash_element(&hash_tables,index); 

    if (!(user=grant_table->user))
      user="";
    if (!(host=grant_table->host))
      host="";

    if (!strcmp(lex_user->user.str,user) &&
2957
	!my_strcasecmp(system_charset_info, lex_user->host.str, host))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2958 2959
    {
      want_access=grant_table->privs;
monty@tramp.mysql.fi's avatar
monty@tramp.mysql.fi committed
2960
      if ((want_access | grant_table->cols) != 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2961
      {
2962
	String global(buff,sizeof(buff),system_charset_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2963 2964 2965
	global.length(0);
	global.append("GRANT ",6);

monty@tramp.mysql.fi's avatar
monty@tramp.mysql.fi committed
2966
	if (test_all_bits(grant_table->privs,(TABLE_ACLS & ~GRANT_ACL)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2967 2968 2969 2970
	  global.append("ALL PRIVILEGES",14);
	else 
	{
	  int found=0;
2971
	  ulong j,test_access= (want_access | grant_table->cols) & ~GRANT_ACL;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025

	  for (counter=0, j = SELECT_ACL;j <= TABLE_ACLS; counter++,j <<= 1)
	  {
	    if (test_access & j) 
	    {
	      if (found)
		global.append(", ",2);
	      found = 1;
	      global.append(command_array[counter],command_lengths[counter]);

	      if (grant_table->cols) 
	      {
		uint found_col=0;
		for (uint col_index=0 ;
		     col_index < grant_table->hash_columns.records ;
		     col_index++)
		{
		  GRANT_COLUMN *grant_column = (GRANT_COLUMN*)
		    hash_element(&grant_table->hash_columns,col_index);
		  if (grant_column->rights & j) 
		  {
		    if (!found_col) 
		    {
		      global.append(" (",2);
		      found_col=1;
		    }
		    else
		      global.append(", ",2);
		    global.append(grant_column->column,
				  grant_column->key_length);
		  }
		}
		if (found_col)
		  global.append(')');
	      }
	    }
	  }
	}
	global.append(" ON ",4);
	global.append(grant_table->db);
	global.append(".",1);
	global.append(grant_table->tname);
	global.append(" TO '",5);
	global.append(lex_user->user.str,lex_user->user.length); 
	global.append("'@'",3);
	global.append(lex_user->host.str,lex_user->host.length); 
	global.append('\'');
	if (want_access & GRANT_ACL)
	  global.append(" WITH GRANT OPTION",18); 
	thd->packet.length(0);
	net_store_data(&thd->packet,global.ptr(),global.length());
	if (my_net_write(&thd->net,(char*) thd->packet.ptr(),
			 thd->packet.length()))
	{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3026
	  error= -1;
3027
	  break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3028 3029 3030 3031 3032 3033
	}
      }
    }
  }
 end:
  VOID(pthread_mutex_unlock(&acl_cache->lock));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3034
  rw_unlock(&LOCK_grant);
3035

3036
  send_eof(thd);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3037 3038 3039 3040
  DBUG_RETURN(error);
}


3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068
/*
  Make a clear-text version of the requested privilege.
*/

void get_privilege_desc(char *to, uint max_length, ulong access)
{
  uint pos;
  char *start=to;
  DBUG_ASSERT(max_length >= 30);		// For end ',' removal

  if (access)
  {
    max_length--;				// Reserve place for end-zero
    for (pos=0 ; access ; pos++, access>>=1)
    {
      if ((access & 1) &&
	  command_lengths[pos] + (uint) (to-start) < max_length)
      {
	to= strmov(to, command_array[pos]);
	*to++=',';
      }
    }
    to--;					// Remove end ','
  }
  *to=0;
}


3069
void get_mqh(const char *user, const char *host, USER_CONN *uc)
3070 3071
{
  ACL_USER *acl_user;
3072 3073 3074 3075
  if (initialized && (acl_user= find_acl_user(host,user)))
    uc->user_resources= acl_user->user_resource;
  else
    bzero((char*) &uc->user_resources, sizeof(uc->user_resources));
3076 3077 3078
}


3079

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3080
/*****************************************************************************
3081
  Instantiate used templates
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3082 3083 3084 3085 3086 3087 3088 3089
*****************************************************************************/

#ifdef __GNUC__
template class List_iterator<LEX_COLUMN>;
template class List_iterator<LEX_USER>;
template class List<LEX_COLUMN>;
template class List<LEX_USER>;
#endif