HIVE-28407 Alter Table Rename should not require create database privilege

[ramesh0201]

What changes were proposed in this pull request?

Currently we add the database object to the list of privilege objects required for authorization in the alter table rename set of queries. Ideally we only need a create table permission on the database and not a create database permission.

Why are the changes needed?

In order to alter table rename we need create database permission on the destination database, which is not required

Does this PR introduce any user-facing change?

No

Is the change a dependency upgrade?

No

How was this patch tested?

[sonarqubecloud[bot]]

Quality Gate passed

Issues
1 New issue
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud

[github-actions[bot]]

This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Feel free to reach out on the [email protected] list if the patch is in need of reviews.