The as [not] default clause is used to assign or remove a login profile as the default login profile.
The following statement alters the login profile named emp_lp as the default login profile.
alter login profile emp_lp as default
The following statement removes the login profile named emp_lp as the default login profile.
alter login profile userGroup_lp as not default
