[YSQL] Enable non-superuser or non-admin users to request information from pg_locks/yb_lock_status

[robertsami]

Jira Link: DB-6248

Description

Before doing this, we need to ensure row/col information from yb_lock_status, and any other potentially sensitive data or PII, is masked unless requested by superuser or db admin.

The range/hash columns for a superuser:

yugabyte=# select hash_cols, range_cols from yb_lock_status(null,null);
    hash_cols  | range_cols 
---------------+------------
               | 
 {1000,"test"} | 
 {1000,"test"} | {3}
(3 rows)

The same range/hash columns will be masked when a regular user queries the tables:

yugabyte=# select hash_cols, range_cols from yb_lock_status(null,null);
 hash_cols | range_cols 
-----------+------------
           | 
  {X,X}    | 
  {X,X}    | {X}
(3 rows)

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.