Generate Select Statement on HANA Table

[sap_cohort]

Hi,  I am able to select "Generate Select Statment" from any tables created in my schema, but seem unable to do this for other tables under the SYS Schema.  I have access to open definition and open content, but do not see the option for Generate Select Statement.  Am I missing an authorization that I am not aware of?   Thanks for any help...

[Former Member · Accepted solution]

Hi Kenneth Murray,

Please Share  what Error message you are getting...

1. Select  Catalog folder

2. SQL editor will be active and click on SQL(Then SQL editor window opens

3. select * from "SCHEMA NAME"."TABLE NAME" LIMIT 10 (execute this syntax in SQL editor)

4. Please share if you get any error message

Regards,

Srihari.

[sap_cohort · Accepted solution]

Hello, If you right-click on a catalog table you see an option for "Generate - Select Statement".  I seem to only be able to do this for my tables and not any other system tables...  Any ideas?  Thanks

[Former Member · Accepted solution]

Hi Kenneth Murray,

looks like it is Authorization issue....

Try to execute below syntax (if you have privileges ) or contact your Admin Team.

GRANT SELECT ON SCHEMA "SCHEMANAME" TO _SYS_REPO WITH GRANT OPTION

Following thread  may help you

Regards,

Srihari.