• unknown's avatar
    support of view underlying tables and SP functions security check added (BUG#9505) (WL#2787) · 24ac4019
    unknown authored
    
    mysql-test/r/information_schema.result:
      error message changed
    mysql-test/r/sp.result:
      error message changed
    mysql-test/r/sql_mode.result:
      fixed test suite
    mysql-test/r/view.result:
      error message changed
    mysql-test/r/view_grant.result:
      test of underlying view tables check
    mysql-test/t/sql_mode.test:
      fixed test suite
    mysql-test/t/view_grant.test:
      test of underlying view tables check
    sql/item.cc:
      check of underlying tables privilege added
    sql/item.h:
      Name the resolution context points to the security  context of view (if item belong to the view)
    sql/item_func.cc:
      a view error hiding for execution of prepared function belonged to a view
      fixed checking privileges if stored functions belonds to some view
    sql/mysql_priv.h:
      refult of derived table processing functions changed to bool
      Security_context added as an argument to find_field_in_table()
    sql/share/errmsg.txt:
      error message fixed
    sql/sql_acl.cc:
      Storing requested privileges of tables added
      View underlying tables privilege check added
    sql/sql_base.cc:
      View underlying tables privilege check added
    sql/sql_cache.cc:
      Code cleunup: we should not register underlying tables of view second time
    sql/sql_delete.cc:
      ancestor -> merge_underlying_list renaming
    sql/sql_derived.cc:
      refult of derived table processing functions changed to bool
      do not give SELECT_ACL for TEMPTABLE views
    sql/sql_lex.h:
      The comment added
    sql/sql_parse.cc:
      registration of requested privileges added
    sql/sql_prepare.cc:
      registration of requested privileges added
    sql/sql_update.cc:
      manipulation of requested privileges for underlying tables made the same as for table which we are updating
    sql/sql_view.cc:
      underlying tables of view security check support added
    sql/table.cc:
      renaming and fixing view preparation methods, methods for checking underlyoing tables security context added
    sql/table.h:
      storege for reuested privileges added
    24ac4019
table.cc 81.4 KB