fix: fix grant/revoke v2 meta and unclear error messages

[shaoting-huang]

related issue: #37031

fixed issues:
#37974: better error messages for grant v2 interface
#37903: fix meta built-in privilege group object name
#37843: better error messages for custom privilege group interface
#38002: fix built-in privilege group meta to pass proxy interceptor check
#38008: fix revoke v2 to support revoking v1 granted privileges

[sre-ci-robot]

[APPROVALNOTIFIER] This PR is NOT APPROVED

This pull-request has been approved by: shaoting-huang
To complete the pull request process, please assign jiaoew1991 after the PR has been reviewed.
You can assign the PR to them by writing /assign @jiaoew1991 in a comment when ready.

The full list of commands accepted by this bot can be found here.

Needs approval from an approver in each of these files:

• configs/OWNERS
• internal/proxy/OWNERS
• internal/rootcoord/OWNERS
• pkg/util/OWNERS
• tests/integration/OWNERS

Approvers can indicate their approval by writing /approve in a comment
Approvers can cancel approval by writing /approve cancel in a comment

[mergify]

@shaoting-huang E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[codecov]

Codecov Report

Attention: Patch coverage is 95.91837% with 2 lines in your changes missing coverage. Please review.

Project coverage is 81.08%. Comparing base (bec5499) to head (2fac18c).

Files with missing lines	Patch %	Lines
internal/rootcoord/root_coord.go	92.00%	2 Missing ⚠️

Additional details and impacted files

@@             Coverage Diff             @@
##           master   #38110       +/-   ##
===========================================
+ Coverage   68.87%   81.08%   +12.21%     
===========================================
  Files         289     1369     +1080     
  Lines       25484   190978   +165494     
===========================================
+ Hits        17551   154863   +137312     
- Misses       7933    30634    +22701     
- Partials        0     5481     +5481     

Components	Coverage Δ
Client	73.67% <ø> (∅)
Core	68.87% <ø> (ø)
Go	83.22% <95.91%> (∅)

Files with missing lines	Coverage Δ
internal/proxy/impl.go	84.84% <100.00%> (ø)
internal/proxy/util.go	89.93% <100.00%> (ø)
internal/rootcoord/meta_table.go	82.75% <100.00%> (ø)
pkg/util/constant.go	98.36% <100.00%> (ø)
pkg/util/merr/errors.go	92.18% <ø> (ø)
pkg/util/merr/utils.go	84.11% <100.00%> (ø)
internal/rootcoord/root_coord.go	89.53% <92.00%> (ø)

... and 1073 files with indirect coverage changes

[shaoting-huang]

/run-cpu-e2e

[mergify]

@shaoting-huang E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[weiliu1031]

/lgtm

[shaoting-huang]

/run-cpu-e2e

[mergify]

@shaoting-huang E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[shaoting-huang]

/run-cpu-e2e

[mergify]

@shaoting-huang E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[sre-ci-robot]

New changes are detected. LGTM label has been removed.

[mergify]

@shaoting-huang E2e jenkins job failed, comment /run-cpu-e2e can trigger the job again.

[mergify]

@shaoting-huang go-sdk check failed, comment rerun go-sdk can trigger the job again.

[shaoting-huang]

/run-cpu-e2e

[shaoting-huang]

rerun go-sdk

[mergify]

@shaoting-huang go-sdk check failed, comment rerun go-sdk can trigger the job again.