[fe]External catalog failed to verify create and insert permissions

[bobo495]

Steps to reproduce the behavior (Required)

1. create hive catalog with ranger

   CREATE EXTERNAL CATALOG `hive_catalog_hms`
   PROPERTIES (
   "hive.metastore.type"  =  "hive",
   "hive.metastore.uris"  =  "thrift://xxx:9083",
   "type"  =  "hive",
   "ranger.plugin.hive.service.name"  =  "hivedev"
   );

2. Use hive user to execute create and insert

   set catalog hive_catalog_hms;
   use `default`;
   create table test1 (id int,name string);
   insert into table test1 values(1,'xxx');

Expected behavior (Required)

create and insert were executed successfully

Real behavior (Required)

create error:

insert error:

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()

  current_version()|
  -----------------+
  3.2.2-269e832    |

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!