select username,password from dba_users; --查看用户信息 select username,account_status from dba_users; --查看用户是否解锁 alter user scott account unlock; --解锁scott用户 alter user scott account lock;--锁scott用户 alter user scott identified by tiger; --为scott用户修改密码为tiger