PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to find the access count of a table/column/database by an user ?

23) How to find the access count of a table/column/database by an user ?

Answer )

SEL LogDate,UserName,ObjectDatabaseName,ObjectTableName

FROM PDCRINFO.DBQLOBJTBLSUM_HST

WHERE ObjectTableName LIKE ‘%XXXXXXXXX%’

AND LOGDATE BETWEEN DATE-30 AND DATE

group by LogDate,UserName,ObjectDatabaseName,ObjectTableName

order by logdate;

Add a Comment

Your email address will not be published. Required fields are marked *