Archives of the TeradataForum

Message Posted: Fri, 10 Oct 2014 @ 10:18:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You need to get it from dbc.dqllogtbl

     Select collecttimestamp,querytext
        from dbc.dbqlogtbl
        where querytext like '% create user XXXX (XXX USERNAME)%'
                  from dbc.dbqlogtbl
                  where Collecttimestamp >= date -n;( where n can be number of days )

	<Prev	Next>		<<First	<Prev	Next>	Last>>