Hello,
I'm looking for a way to find information about a set of Aster tables- specifically who(userid) queries them.
What would be the best way to get this info?
You can have a look at the same using AMC or if you wanna check it with a sql Query you can us the NC_tables.
The data dictionary view nc_all_statements contains information about recently executed statements in Aster Database. By default, the table retains three days worth of statements, but your asterdata.com/support representative can change the retention policy for you.
you can frame a query where you wanna see tablename like in <statement> and pull out the sessionid and then can relate the sessionids and Userids.
hopefully this helps.
Thank you!