Skip to Content

End Users to be connected through only HTTP/HTTPS

Hi Experts ,

I have a requirement where the End user can only be connected to SAP HANA from HTTP/HTTPS.  I don't want user to get connected from HANA STUDIO.

I can't create the restricted user as restricted user can insert a row in database or can change anything in database. So the restricted user will not work for me.

Any help on these is highly appreciated.

-

Pratik

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2015 at 06:11 AM

    Hi Pratik,

    I don't know from where you heard that restricted user can make changes in the database.

    When you create Restricted User, it does not get any predefined roles not even PUBLIC role and can connect to HANA only via HTTP/HTTPS.

    Restricted User can't perform anything, he can not even create objects in its own schema.

    Whatever authorizations you give him that will only work.

    For your requirement, You can create a restricted User and just give him access to Views that are used by your App and that should be enough.

    Additionally, you can check my blog:

    HANA Security: Creating End Users with minimal rights

    For more details on restricted user, read HANA Security Guide:

    User Types - SAP HANA Security Guide - SAP Library

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded