设为首页收藏本站

Botang唐波's Oracle Station

查看: 60|回复: 2

课程第6次(2018-10-11星期四)

[复制链接]

731

主题

1102

帖子

8002

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8002
发表于 2018-10-11 20:19:17 | 显示全部楼层 |阅读模式
  1. select  u.username,
  2.             u.account_status,
  3.             u.lock_date,
  4.             u.expiry_date
  5. from dba_users u
  6. where u.username in ('USER1','SH','OE');

  7. alter user user1 account lock password expire;

  8. alter user user1 account unlock;

  9. select  * from dba_col_privs  cp
  10.   where cp.grantee='USER1';

  11. select  * from system_privilege_map;

  12. select  * from dba_roles;

  13. create role role1 ;

  14. grant update ( salary) on hr.employees  to role1;

  15. grant role1 to user1;

  16. revoke update on hr.employees from role1;

  17.   grant update ( salary) on hr.employees  to role1;
  18.   
  19.   revoke role1 from user1;
  20.   
  21.    grant role1 to user1;
  22.    
  23.    
  24.    select  * from dba_role_privs  rp
  25.     where rp.grantee='USER1';
  26.    
  27.     alter user user1 default role connect;
  28.    
  29.       alter user user1 default role  none;
  30.       
  31.       alter user user1 default role connect;
  32.       
  33.       create role role2 identified by oracle_4U;
  34.       
  35.       grant role2 to user1;
复制代码
图形界面的bug:
1.png


  1. select  u.username,
  2.             u.account_status,
  3.             u.lock_date,
  4.             u.expiry_date
  5. from dba_users u
  6. where u.username in ('USER1','SH','OE');

  7. select  * from dba_profiles p
  8. where p.profile='PROFILE1';

  9. alter profile profile1 limit
  10.   PASSWORD_REUSE_TIME .013888
  11.   PASSWORD_REUSE_MAX 1;
  12.   
复制代码
  1. SQL> conn user1/oracle_4U
  2. ERROR:
  3. ORA-28002: the password will expire within 0 days


  4. Connected.
  5. SQL> conn user1/oracle_4U
  6. ERROR:
  7. ORA-28002: the password will expire within 0 days


  8. Connected.
  9. SQL> conn user1/oracle_4U
  10. ERROR:
  11. ORA-28002: the password will expire within 0 days


  12. Connected.
  13. SQL> conn user1/oracle_4U
  14. ERROR:
  15. ORA-28002: the password will expire within 0 days


  16. Connected.
  17. SQL> conn user1/oracle_4U
  18. ERROR:
  19. ORA-28002: the password will expire within 0 days


  20. Connected.
  21. SQL> conn user1/oracle_4U
  22. ERROR:
  23. ORA-28002: the password will expire within 0 days


  24. Connected.
  25. SQL> conn user1/oracle_4U
  26. ERROR:
  27. ORA-28002: the password will expire within 0 days


  28. Connected.
  29. SQL> conn user1/oracle_4U
  30. ERROR:
  31. ORA-28002: the password will expire within 0 days


  32. Connected.
  33. SQL> conn user1/oracle_4U
  34. ERROR:
  35. ORA-28002: the password will expire within 0 days


  36. Connected.
  37. SQL> conn user1/oracle_4U
  38. ERROR:
  39. ORA-28002: the password will expire within 0 days


  40. Connected.
  41. SQL> conn user1/oracle_4U
  42. ERROR:
  43. ORA-28002: the password will expire within 0 days


  44. Connected.
  45. SQL> conn user1/oracle_4U
  46. ERROR:
  47. ORA-28002: the password will expire within 0 days


  48. Connected.
  49. SQL> conn user1/oracle_4U
  50. ERROR:
  51. ORA-28002: the password will expire within 0 days


  52. Connected.
  53. SQL> conn user1/oracle_4U
  54. ERROR:
  55. ORA-28002: the password will expire within 0 days


  56. Connected.
  57. SQL> conn user1/oracle_4U
  58. ERROR:
  59. ORA-28002: the password will expire within 0 days


  60. Connected.
  61. SQL> conn user1/oracle_4U
  62. ERROR:
  63. ORA-28002: the password will expire within 0 days


  64. Connected.
  65. SQL> conn user1/oracle_4U
  66. ERROR:
  67. ORA-28002: the password will expire within 0 days


  68. Connected.
  69. SQL> conn user1/oracle_4U
  70. ERROR:
  71. ORA-28002: the password will expire within 0 days


  72. Connected.
  73. SQL> conn user1/oracle_4U
  74. ERROR:
  75. ORA-28002: the password will expire within 0 days


  76. Connected.
  77. SQL> conn user1/oracle_4U
  78. ERROR:
  79. ORA-28002: the password will expire within 0 days


  80. Connected.
  81. SQL> conn user1/oracle_4U
  82. ERROR:
  83. ORA-28002: the password will expire within 0 days


  84. Connected.
  85. SQL> conn user1/oracle_4U
  86. ERROR:
  87. ORA-28001: the password has expired


  88. Changing password for user1
  89. New password: *********
  90. Retype new password: *********
  91. ERROR:
  92. ORA-28007: the password cannot be reused


  93. Password unchanged
  94. Warning: You are no longer connected to ORACLE.
  95. SQL> conn user1/oracle_4U
  96. ERROR:
  97. ORA-28001: the password has expired


  98. Changing password for user1
  99. New password: *********
  100. Retype new password: *********
  101. Password changed
  102. Connected.
  103. SQL> conn user1/oracle_5U
  104. Connected.
  105. SQL> conn user1/oracle_5U
  106. Connected.
  107. SQL> conn user1/oracle_5U
  108. Connected.
  109. SQL> conn user1/oracle_5U
  110. Connected.
  111. SQL> conn user1/oracle_5U
  112. Connected.
  113. SQL> conn user1/oracle_5U
  114. Connected.
  115. SQL> conn user1/oracle_5U
  116. Connected.
  117. SQL> conn user1/oracle_5U
  118. Connected.
  119. SQL> conn user1/oracle_5U
  120. ERROR:
  121. ORA-28002: the password will expire within 0 days


  122. Connected.
  123. SQL> conn user1/oracle_5U
  124. ERROR:
  125. ORA-28002: the password will expire within 0 days


  126. Connected.
  127. SQL> conn user1/oracle_5U
  128. ERROR:
  129. ORA-28002: the password will expire within 0 days


  130. Connected.
  131. SQL> conn user1/oracle_5U
  132. ERROR:
  133. ORA-28002: the password will expire within 0 days


  134. Connected.
  135. SQL> conn user1/oracle_5U
  136. ERROR:
  137. ORA-28002: the password will expire within 0 days


  138. Connected.
  139. SQL> conn user1/oracle_5U
  140. ERROR:
  141. ORA-28002: the password will expire within 0 days


  142. Connected.
  143. SQL> conn user1/oracle_5U
  144. ERROR:
  145. ORA-28002: the password will expire within 0 days


  146. Connected.
  147. SQL> conn user1/oracle_5U
  148. ERROR:
  149. ORA-28002: the password will expire within 0 days


  150. Connected.
  151. SQL> conn user1/oracle_5U
  152. ERROR:
  153. ORA-28002: the password will expire within 0 days


  154. Connected.
  155. SQL> conn user1/oracle_5U
  156. ERROR:
  157. ORA-28001: the password has expired


  158. Changing password for user1
  159. New password: *********
  160. Retype new password: *********
  161. ERROR:
  162. ORA-28007: the password cannot be reused


  163. Password unchanged
  164. Warning: You are no longer connected to ORACLE.
  165. SQL> conn user1/oracle_5U
  166. ERROR:
  167. ORA-28001: the password has expired


  168. Changing password for user1
  169. New password: *********
  170. Retype new password: *********
  171. ERROR:
  172. ORA-28007: the password cannot be reused


  173. Password unchanged
  174. SQL> conn user1/oracle_5U
  175. ERROR:
  176. ORA-28001: the password has expired


  177. Changing password for user1
  178. New password: *********
  179. Retype new password: *********
  180. ERROR:
  181. ORA-28007: the password cannot be reused


  182. Password unchanged
  183. SQL> conn user1/oracle_5U
  184. ERROR:
  185. ORA-28001: the password has expired


  186. Changing password for user1
  187. New password: *********
  188. Retype new password: *********
  189. Password changed
  190. Connected.
  191. SQL> conn user1/oracle_4U
  192. Connected.
  193. SQL>
复制代码




上完1Z0-052 第8章 用户(4/40)
回复

使用道具 举报

1

主题

9

帖子

83

积分

注册会员

Rank: 2

积分
83
发表于 6 天前 来自手机 | 显示全部楼层
唐老师,启动图形界面报错这个怎么解决?
2018-10-16_14.25.02.jpg
回复 支持 反对

使用道具 举报

731

主题

1102

帖子

8002

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8002
 楼主| 发表于 6 天前 | 显示全部楼层
chenmd 发表于 2018-10-16 14:25
唐老师,启动图形界面报错这个怎么解决?

em  not configured.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-10-22 02:43 , Processed in 0.206312 second(s), 26 queries .

快速回复 返回顶部 返回列表