We would like to generate user database usage report in SAS Environment. We have SAS Access to Netezza configured to access Netezza database. Is it possible to list such user usage reports using SAS scripts or sourcing SAS logs. Appreciate if you cold advise.
Using explicit SQL Pass-through you can query directly the database with native Netezza SQL. Not sure what level of information Netezza stores but whatever is there can be queried out of SAS.
Assuming that such information is likely admin level you would of course also need the required privileges for the user connecting to Netezza to have access to such information.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.