测试指定profile 分配给用户后，是否可以直接删除profile文件

jiawang

创建 profile
SQL> create profile wangjia limit failed_login_attempts 7;
Profile created.


创建用户test
SQL> create user test  identified by test;
User created.


指定 profile
SQL> alter user test profile wangjia;
User altered.


查看 test 的 profile
SQL> select PROFILE from dba_users where username='TEST';
PROFILE
------------------------------
WANGFJIA


测试删除，删除失败
SQL> drop profile wangjia;
drop profile wangjia
*
ERROR at line 1:
ORA-02382: profile wangjia has users assigned, cannot drop without CASCADE


修改为默认的 profile
SQL> alter user test profile default;
User altered.


测试删除，删除成功
SQL> drop profile wangjia;
Profile dropped.


综上：profile 分配给用户后，必须取消才可以删除 profile 文件