SQL>
SQL> ALTER USER SCOTT ACCOUNT LOCK;

User altered.

SQL> connect scott/tiger
ERROR:
ORA-28000: compte verrouille


Warning: You are no longer connected to ORACLE.
SQL>

SQL>
SQL> ALTER USER SCOTT ACCOUNT UNLOCK;

User altered.

SQL> connect scott/tiger
Connected.
SQL>

SQL>
SQL> ALTER USER SCOTT PASSWORD EXPIRE;

User altered.

SQL> connect scott/tiger
ERROR:
ORA-28001: le mot de passe est expire


Changing password for scott
New password:
Retype new password:

Password changed
Connected.

SQL> connect scott/change
Connected.
SQL>

SQL>
SQL> SELECT   * FROM V$PWFILE_USERS;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE

SQL>

SQL>
SQL> SET LINESIZE 110
SQL> SELECT   USERNAME,
  2           TABLESPACE_NAME,
  3           DECODE (SIGN (MAX_BYTES), -1, 'UNLIMITED', 'QUOTA') "QUOTA ?"
  4    FROM   DBA_TS_QUOTAS
  5   WHERE   USERNAME IN ('RMAN', 'SCOTT');

USERNAME                       TABLESPACE_NAME                QUOTA ?
------------------------------ ------------------------------ ---------
RMAN                           RMAN_CATALOG                   UNLIMITED
RMAN                           DATA                           QUOTA
SCOTT                          DATA                           UNLIMITED

SQL>