Oracle - Profile

梦里梦外; 2022-08-28 13:50 7阅读 0赞

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_13_color_FFFFFF_t_70_g_se_x_16]

col profile format a50
    col username format a50
    select username, profile from dba_users;

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]

select * from sys.user_resource_limits;

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_12_color_FFFFFF_t_70_g_se_x_16]

col limit format a30
    col profile format a20
    col resource_name format a30
    col resource_type format a20
    select * from sys.dba_profiles;

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16 1]  
password\_life\_time：密码过期策略  
failed\_login\_attempts：登录失败次数锁定

*  [Profile详解][Profile]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_13_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/761701a778fd4a7290428f8193091365.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/6a9a7bd1cdaa4d7bbb8d9c59306f20ef.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_12_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/2b2d4dcebcae45bcb079b519e0e6c1cf.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220828/8494a94908b4412ba05033c7370d11da.png
[Profile]: https://www.cnblogs.com/polestar/p/9263831.html