Search code examples
hanahana-xs

Is it true that each new user in SAP HANA is assigned a schema with the same name as the user?

It seems to be that, every time a new user is created in HANA, a new schema with the same name as the user is created too.

  • Is this always true or this is a configurable behaviour?
  • If this is always true, can you provide the link in the official documentation of SAP Hana where this behaviour is explained? I could not find it after searching in the official docs.
Solution

  • It's the normal behavior of SAP HANA and it's not configurable. https://answers.sap.com/questions/12096524/index.html

    Here is the documentation link for SAP HANA user: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-US/20d5ddb075191014b594f7b11ff08ee2.html

    A schema with the user's name is created for each database user: this schema cannot be explicitly dropped. The user's schema is automatically dropped when the user is deleted. The database user owns this schema and it is used as their default schema when they execute a command without explicitly specifying a schema name.