Oracle unexpire password - Cronologia

WikiSysop: /* modifica del profilo default */

2024-11-07T08:33:10Z

modifica del profilo default

2024-11-07T08:30:58Z

modifica del profilo default

← Versione meno recente		Versione delle 08:30, 7 nov 2024
Riga 98:		Riga 98:

	===modifica del profilo default===		===modifica del profilo default===

			Verifica profilo di default:

			col profile for a30
			col limit for a20
			select * from dba_profiles where profile='DEFAULT';

			Modifica profilo di default:

	alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited PASSWORD_GRACE_TIME unlimited FAILED_LOGIN_ATTEMPTS unlimited PASSWORD_VERIFY_FUNCTION null;		alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited PASSWORD_GRACE_TIME unlimited FAILED_LOGIN_ATTEMPTS unlimited PASSWORD_VERIFY_FUNCTION null;
	alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited PASSWORD_GRACE_TIME unlimited;		alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited PASSWORD_GRACE_TIME unlimited;

2024-11-07T08:26:40Z

Imposta per evitare la scadenza

← Versione meno recente		Versione delle 08:26, 7 nov 2024
Riga 96:		Riga 96:
	/		/
	</pre>		</pre>

			===modifica del profilo default===
			alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited PASSWORD_GRACE_TIME unlimited FAILED_LOGIN_ATTEMPTS unlimited PASSWORD_VERIFY_FUNCTION null;
			alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited PASSWORD_GRACE_TIME unlimited;

	=Password Unexpire=		=Password Unexpire=

2023-11-14T10:34:32Z

Versione 11G

← Versione meno recente		Versione delle 10:34, 14 nov 2023
Riga 119:		Riga 119:
	set linesize 400		set linesize 400
	select 'alter user ' \|\| t1.username \|\| ' identified by values ''' \|\| t2.password \|\| ';' \|\| t2.spare4 \|\| ''';'		select 'alter user ' \|\| t1.username \|\| ' identified by values ''' \|\| t2.password \|\| ';' \|\| t2.spare4 \|\| ''';'
	from dba_users t1, sys.user$ t2 where t2.name=t1.username and t1.account_status in ('EXPIRED','EXPIRED(GRACE)') and t2.password is not null and t2.spare4 is not null;		from dba_users t1, sys.user$ t2 where t2.name=t1.username and t1.account_status in ('EXPIRED','EXPIRED(GRACE)') and t2.password is not null and t2.spare4 is not null
			union

	select 'alter user ' \|\| t1.username \|\| ' identified by values ''' \|\| t2.spare4 \|\| ''';'		select 'alter user ' \|\| t1.username \|\| ' identified by values ''' \|\| t2.spare4 \|\| ''';'
	from dba_users t1, sys.user$ t2 where t2.name=t1.username and t1.account_status in ('EXPIRED','EXPIRED(GRACE)') and t2.password is null and t2.spare4 is not null;		from dba_users t1, sys.user$ t2 where t2.name=t1.username and t1.account_status in ('EXPIRED','EXPIRED(GRACE)') and t2.password is null and t2.spare4 is not null;

	</pre>		</pre>

2023-10-26T10:43:09Z

versione singola

← Versione meno recente		Versione delle 10:43, 26 ott 2023
Riga 224:		Riga 224:
	/		/
	</pre>		</pre>
	Versione con cambio di profilo		===Versione con cambio di profilo===
	<pre>		<pre>
	begin		begin

2023-10-26T10:42:46Z

versione singola

← Versione meno recente		Versione delle 10:42, 26 ott 2023
Riga 217:		Riga 217:
	where t2.name=t1.username		where t2.name=t1.username
	and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')		and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')
	and (t1.password_versions='~~10G~~ 11G 12C ' ~~or t1.password_versions=~~'10G 11G 12C ') )		and t1.password_versions in ('11G 12C ','10G 11G 12C ') )
	loop		loop
	execute immediate 'alter user ' \|\| c1.u \|\| ' identified by values ''' \|\| c1.p \|\| ';' \|\| c1.s \|\| ''' ';		execute immediate 'alter user ' \|\| c1.u \|\| ' identified by values ''' \|\| c1.p \|\| ';' \|\| c1.s \|\| ''' ';
Riga 232:		Riga 232:
	and t1.profile='DOMAIN_USERS'		and t1.profile='DOMAIN_USERS'
	and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')		and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')
	and (t1.password_versions='~~10G~~ 11G 12C ' ~~or t1.password_versions=~~'10G 11G 12C '))		and t1.password_versions in ('11G 12C ','10G 11G 12C '))
	loop		loop
	execute immediate 'alter user ' \|\| c1.u \|\| ' profile default';		execute immediate 'alter user ' \|\| c1.u \|\| ' profile default';

2023-10-26T10:41:26Z

versione singola

← Versione meno recente		Versione delle 10:41, 26 ott 2023
Riga 217:		Riga 217:
	where t2.name=t1.username		where t2.name=t1.username
	and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')		and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')
	and t1.password_versions='10G 11G 12C ')		and (t1.password_versions='10G 11G 12C ' or t1.password_versions='10G 11G 12C ') )
	loop		loop
	execute immediate 'alter user ' \|\| c1.u \|\| ' identified by values ''' \|\| c1.p \|\| ';' \|\| c1.s \|\| ''' ';		execute immediate 'alter user ' \|\| c1.u \|\| ' identified by values ''' \|\| c1.p \|\| ';' \|\| c1.s \|\| ''' ';
Riga 224:		Riga 224:
	/		/
	</pre>		</pre>
			Versione con cambio di profilo
	<pre>		<pre>
	begin		begin
	for c1 in (select t1.username u,t2.password p,t2.spare4 s		for c1 in (select t1.username u,t2.password p,t2.spare4 s
	from dba_users t1, sys.user$ t2		from dba_users t1, sys.user$ t2
	where t2.name=t1.username		where t2.name=t1.username
			and t1.profile='DOMAIN_USERS'
	and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')		and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')
	and t1.password_versions='11G 12C ')		and (t1.password_versions='10G 11G 12C ' or t1.password_versions='10G 11G 12C '))
	loop		loop
			execute immediate 'alter user ' \|\| c1.u \|\| ' profile default';
	execute immediate 'alter user ' \|\| c1.u \|\| ' identified by values ''' \|\| c1.p \|\| ';' \|\| c1.s \|\| ''' ';		execute immediate 'alter user ' \|\| c1.u \|\| ' identified by values ''' \|\| c1.p \|\| ';' \|\| c1.s \|\| ''' ';
			execute immediate 'alter user ' \|\| c1.u \|\| ' profile DOMAIN_USERS';

	end loop;		end loop;
	end;		end;

2022-10-26T09:55:05Z

Interroga

← Versione meno recente		Versione delle 09:55, 26 ott 2022
Riga 6:		Riga 6:
	col username for a30		col username for a30
	col profile for a40		col profile for a40
	select username,profile,created from dba_users where account_status in ('EXPIRED','EXPIRED(GRACE)');		select username,profile,created,account_status from dba_users where account_status in ('EXPIRED','EXPIRED(GRACE)') order by username;
	</pre>		</pre>

2022-08-23T09:54:43Z

Versione 12C

@@ Riga 188: / Riga 188: @@
               where t2.name=t1.username
                 and t1.account_status in ('EXPIRED','EXPIRED(GRACE)')
-                and t1.password_versions in ('12C ','11G ','11G 12C ','10G 11G 12C ')
+                and t1.password_versions in ('12C ','11G ','11G 12C ')
   loop
    execute immediate 'alter user ' || c1.u || ' identified by values ''' || c1.p || ';' || c1.s || ''' ';

2022-08-23T09:51:03Z

Versione 12C

@@ Riga 169: / Riga 169: @@
 ==Versione 12C==
 <pre>
  begin
@@ Riga 220: / Riga 194: @@
  end;
+ /
 </pre>