Clear the login_failures table...

Moderator: NorbertKrupa

Post Reply
harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Clear the login_failures table...

Post by harryrundles » Mon Sep 17, 2012 8:10 pm

Hi there,

There is a system table named login_failures that tracks user login failures. Is there a safe way to delete data from this table?

Thanks!
Thanks,
Harry

scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Clear the login_failures table...

Post by scutter » Mon Sep 17, 2012 11:56 pm

Try

select clear_data_collector_collector('LoginFailures');

which clears the underlying Data Collector table dc_login_failures table.

--Sharon
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Re: Clear the login_failures table...

Post by harryrundles » Wed Sep 19, 2012 6:02 pm

Thanks, Sharon! This will help me in the future. Is there an option to clear data based on some criteria? That is, on a date?
Thanks,
Harry

scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Clear the login_failures table...

Post by scutter » Thu Sep 20, 2012 3:38 am

Just saw my typo in my previous post - should have been clear_data_collector() of course.

The retention policy is only based on amount of data - there aren't currently any other criteria that can be used to trigger clearing it.
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Re: Clear the login_failures table...

Post by harryrundles » Thu Sep 20, 2012 12:15 pm

Sharon, thanks, again!!!
Thanks,
Harry

Post Reply

Return to “New to Vertica Database Administration”