课程第6次（2018-10-11星期四）

botang · 发表于 2018-10-11 20:19:17

select u.username,
u.account_status,
u.lock_date,
u.expiry_date
from dba_users u
where u.username in ('USER1','SH','OE');
alter user user1 account lock password expire;
alter user user1 account unlock;
select * from dba_col_privs cp
where cp.grantee='USER1';
select * from system_privilege_map;
select * from dba_roles;
create role role1 ;
grant update ( salary) on hr.employees to role1;
grant role1 to user1;
revoke update on hr.employees from role1;
grant update ( salary) on hr.employees to role1;
revoke role1 from user1;
grant role1 to user1;
select * from dba_role_privs rp
where rp.grantee='USER1';
alter user user1 default role connect;
alter user user1 default role none;
alter user user1 default role connect;
create role role2 identified by oracle_4U;
grant role2 to user1;

复制代码

图形界面的bug：

select u.username,
u.account_status,
u.lock_date,
u.expiry_date
from dba_users u
where u.username in ('USER1','SH','OE');
select * from dba_profiles p
where p.profile='PROFILE1';
alter profile profile1 limit
PASSWORD_REUSE_TIME .013888
PASSWORD_REUSE_MAX 1;

复制代码

SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_4U
ERROR:
ORA-28001: the password has expired
Changing password for user1
New password: *********
Retype new password: *********
ERROR:
ORA-28007: the password cannot be reused
Password unchanged
Warning: You are no longer connected to ORACLE.
SQL> conn user1/oracle_4U
ERROR:
ORA-28001: the password has expired
Changing password for user1
New password: *********
Retype new password: *********
Password changed
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28002: the password will expire within 0 days
Connected.
SQL> conn user1/oracle_5U
ERROR:
ORA-28001: the password has expired
Changing password for user1
New password: *********
Retype new password: *********
ERROR:
ORA-28007: the password cannot be reused
Password unchanged
Warning: You are no longer connected to ORACLE.
SQL> conn user1/oracle_5U
ERROR:
ORA-28001: the password has expired
Changing password for user1
New password: *********
Retype new password: *********
ERROR:
ORA-28007: the password cannot be reused
Password unchanged
SQL> conn user1/oracle_5U
ERROR:
ORA-28001: the password has expired
Changing password for user1
New password: *********
Retype new password: *********
ERROR:
ORA-28007: the password cannot be reused
Password unchanged
SQL> conn user1/oracle_5U
ERROR:
ORA-28001: the password has expired
Changing password for user1
New password: *********
Retype new password: *********
Password changed
Connected.
SQL> conn user1/oracle_4U
Connected.
SQL>

复制代码

上完1Z0-052 第8章用户（4/40）

chenmd · 发表于 2018-10-16 14:25:27

唐老师，启动图形界面报错这个怎么解决？

botang · 发表于 2018-10-16 16:05:24

chenmd 发表于 2018-10-16 14:25
唐老师，启动图形界面报错这个怎么解决？

em not configured.