SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

[former_member589392]

I am not able to execute this query.
select * from sys.columns

This issue is getting while executing the query 'SAP DBTech JDBC: [258]: insufficient privilege: Not authorized'

My Hana login user is not as 'System'. Its name like HBDSYSAM.

Please help me on this

[Ivan-Mirisola · Accepted solution]

Hi Jithin,

"sys.column" is an internal system view that can only be accessed by the SYSTEM user and AFAIK you can't assign privileges to normal users.

Instead, you could be using the following statement:

select * from sys.table_columns where SCHEMA_NAME like 'SAPABAP1' and TABLE_NAME like 'ADRC';

This should give you a list of table columns that is somewhat similar as the 'desc <table_name>' command from other SQL engines.

A list of standard system priviledges can be found here.

Best regards,
Ivan

[former_member589392 · Accepted solution]

Thanks Ivan . Its worked. I changed the query as select * from sys.table_columns . Thanks for your answer