[Bug]: The sql window requires DBA authority to query sys.v$nls_parameters. The authority is too high.

[Huangxiao-mas]

ODC version

ODC424bp2

OB version

native oracle 11g

What happened?

The sql window requires DBA authority to query sys.v$nls_parameters. The authority is too high.

What did you expect to happen?

Just have the permission to select any dictionary

How can we reproduce it (as minimally and precisely as possible)?

Use only query permission to execute the following statement in the sql window SELECT VALUE FROM SYS.V$PARAMETER WHERE NAME = 'nls_date_format'; SELECT VALUE FROM SYS.V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_DATE_FORMAT';

Anything else we need to know?

No response