How to track who accessed particular Business Schemas

[nour_ashraf]

Ever wonder who has been accessing Business Schemas?  We can get these details from the metadata DB by using this query:

SELECT us.`name`, sc.`name` FROM incorta_db_dev_523.ACTION ac 
join incorta_db_dev_523.`user` us on ac.userid = us.id and ac.tenantid = us.TENANTID
join incorta_db_dev_523.`schema` sc on sc.id = entityid 
where sc.loaderdata is null and entitytype = 5;