how to set noexpiration_date for all users in DB: Oracle11g

[Ramakanta Sahoo]

Hi,
Could anyone please tell me how to set (password)noexpiration_date for all users present in a DB oracle 11g.
May be this will set for only one user.
alter user SYSTEM with noexpiration_date;
I want to set it for all users so that noones password expires ever.

please help.
thanks,
ricky
[ September 04, 2008: Message edited by: Ricky Rosan ]

[J. Solis]

Run in sqlplus:
spool noexp_users
select 'alter user ' || user_name ' with noexpiration_date;' from dba_users;
spool off

With this you have created a file called noexp_users with the sentences to modify all the users.

Now edit the file to remove the non-sql lines.

Next, in sqlplus run:
@noexp_users

With this you run the script previouly created.

Regards

[Ramakanta Sahoo]

This will only enable the users currently present in the DB.
but my problem is I want to alter full DB's as no expiration . So that if a new schema is created afterwards that ll not also expire.So if anyone knows how to do it then please advice.