Function get_column_grant

sql/sql_acl.cc:9245–9297

*/

privilege_t get_column_grant(THD *thd, GRANT_INFO *grant,
                        const char *db_name, const char *table_name,
                        const Lex_ident_column &field_name)
{
  GRANT_TABLE *grant_table;
  GRANT_TABLE *grant_table_role;
  GRANT_TABLE *grant_public;
  GRANT_COLUMN *grant_column;
  privilege_t priv(NO_ACL);

  mysql_rwlock_rdlock(&LOCK_grant);
  /* reload table if someone has modified any grants */
  grant->refresh(thd->security_ctx, db_name, table_name);

  grant_table= grant->grant_table_user;
  grant_table_role= grant->grant_table_role;
  grant_public= grant->grant_public;

  if (!grant_table && !grant_table_role && !grant_public)
    priv= grant->privilege;
  else
  {
    if (grant_table)
    {
      grant_column= column_hash_search(grant_table, field_name);
      if (!grant_column)
        priv= (grant->privilege | grant_table->privs);
      else
        priv= (grant->privilege | grant_table->privs | grant_column->rights);
    }

    if (grant_table_role)
    {
      grant_column= column_hash_search(grant_table_role, field_name);
      if (!grant_column)
        priv|= (grant->privilege | grant_table_role->privs);
      else
        priv|= (grant->privilege | grant_table_role->privs |
                grant_column->rights);
    }
    if (grant_public)
    {
      grant_column= column_hash_search(grant_public, field_name);
      if (!grant_column)
        priv|= (grant->privilege | grant_public->privs);
      else
        priv|= (grant->privilege | grant_public->privs |
                grant_column->rights);
    }
  }
  mysql_rwlock_unlock(&LOCK_grant);
  return priv;
}


/* Help function for mysql_show_grants */