Checking schema creation in SAP HANA database

SAP HANASAPSAP Basis

To check this detail, you should have access on “SYS” schema. Run the following SQL query and it will fetch the following columns −

SELECT * FROM "SYS"."SCHEMAS";
  • Schema_Name
  • Schema_Owner
  • HAS_PRIVILEGES
  • Create_Time

raja
Updated on 13-Mar-2020 07:54:21

Advertisements