Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28455

CREATE TEMPORARY TABLES privilege is insufficient for SHOW COLUMNS

    XMLWordPrintable

Details

    Description

      CREATE TEMPORARY TABLES privilege is supposed to allow all actions with temporary tables created by the session.
      However, while it also allows to run SHOW COLUMNS on such tables, it's not sufficient to get a result, it remains empty.
      Oddly, SHOW INDEX works.

      create database db;
      		 
      create user foo@localhost;
      		 
      grant create temporary tables on db.* to foo@localhost;
      		 
       
      		 
      --connect (con1,localhost,foo,,db)
      		 
      create temporary table tmp (a int, key(a));
      		 
      show create table tmp;
      		 
      show columns in tmp;
      		 
      show index in tmp;
      		 
       
      		 
      # Cleanup
      		 
      --disconnect con1
      		 
      --connection default
      		 
      drop database db;
      		 
      drop user foo@localhost;

      bb-10.9-anel 32274c3e8a4

      		 
      show columns in tmp;
      		 
      Field	Type	Null	Key	Default	Extra
      		 
      show index in tmp;
      		 
      Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment	Ignored
      		 
      tmp	1	a	1	a	A	NULL	NULL	NULL	YES	BTREE			NO

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28544 Appending SELECT privilege not applied on show columns and show index

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28548 ER_TABLEACCESS_DENIED_ERROR is missing information about DB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28783 Privilege inconsistency between show columns and information_schema.columns

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-12459 The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28544 Appending SELECT privilege not applied on show columns and show index

          • Major - Major loss of function.
          • Closed
          links to

          Web Link PR #2180

          Activity

            People

              anel Anel Husakovic
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.