Skip to Content

HR Table restriction on SAP ECC HANA database

Hello Everyone,

We have recently migrated to ECC Hana data base and there are few developers who need access to HANA database.

The developer says that he needs access for SAP default schema which gives access for all tables in SAP and they are worried that creating customized schema with tables they need may involve more work as they need to replicate the data each time to default schema each time and they need access to most of the tables in SAP

Please advise Is there a way that we can restrict HR /critical tables from SAP default schema so that developer cannot query the data in ECC database.

Please advise on the correct approach on this issue.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 14, 2016 at 05:50 PM

    Hi Sanjeev,

    Below link has few solutions to achieve this. Rather than giving full access on entire schema give required access only on particular tables OR create a custom role with access on Schema but not on specific tables.


    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2016 at 06:06 PM

    Harish , Thanks for your reply.. I have already created a custom role using WEB IDE which gives select access for SAP default schema.

    However I don't see any further option to restrict the table from viewing. The minimum access I could give for the table is select which gives access for viewing the contents in the table. Please let me know is there any field which could restrict on table from viewing.

    Add comment
    10|10000 characters needed characters exceeded