[Bug]: mo_transactions and mo_locks break tenant isolation

[aylei]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

2eeef92

Other Environment Information

- Hardware parameters: 
- OS type:
- Others:

Actual Behavior

> select * from mo_catalog.mo_transactions;
....
> select * from mo_catalog.mo_locks;
....

The above SQLs will return all locks and transactions among all accounts, which break multi-tenant isolation.

Expected Behavior

No response

Steps to Reproduce

Tenant should only see its own locks and txns.

Additional information

No response