Archives of the TeradataForum

Message Posted: Thu, 12 Jul 2012 @ 17:04:29 GMT


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

Subj:		Re: Finding a dropped user

From:		Dave Wellman

Hi James,

Not specifically. As with all database objects, when a user is dropped then the entire definition of that object is removed from all relevant dictionary tables. The only chance you have of finding when the user was dropped is by recording the command in Query and/or Access log.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)