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
Published on 25-Apr-2018 23:30:42
Advertisements