permission denied when selecting system table (isystab)

[Former Member]

Hi, Experts

permission denied when selecting system table(isystab) even if dba....

select * from isystab; --- error

select * from sys.isystab; --- error

Which privilege is needed to select system table?

Thanks in advance

[Gisung · Accepted solution]

Hi,

The following system table can't be approached by users.

You can get the same data with view of ISYSTAB.

select * from systab;

Best regards,

Gi-Sung Jang

[Former Member · Accepted solution]

Thank you for your quick answer.

Have a nice day.