Changing a standard user account to a restricted user account in SAP HANA involves modifying specific attributes to limit the user's capabilities and access within the database:
* Disable ODBC/JDBC Access must be set to "Yes" (A): This prevents the user from connecting to the database using ODBC or JDBC, which are common connectivity methods for external applications and development environments.
* Creation of Objects in Own Schema must be set to "No" (C): Restricted users should not have the privilege to create new objects in their schema, ensuring that their activities are limited to predefined tasks and roles.
* PUBLIC role must be set to "No" (E): Removing the PUBLIC role restricts the user from inheriting any privileges that are generally available to all database users, further limiting their access and capabilities. The options related to Authorization method being set to "LDAP" (B) and User Group must be set to "Restricted" (D) arenot directly related to changing the user account type in SAP HANA but pertain to different aspects of user authentication and group categorization.
References= The conversion between standard and restricted user types is detailed in the SAP HANA security and user administration documentation, highlighting the attribute adjustments necessary for enforcing stricter access controls.
User Management