ORA-01045: user lacks CREATE SESSION privilege; logon denied，修改密码

报‘ORA-01045: user lacks CREATE SESSION privilege; logon denied’，原来是创建User时没有给赋上create session权限，
解决办法：grant create session,resource to <user>

或在pl/sql developer里，创建user时选择system privileges->create session

修改密码：

alter user MSKY identified by SA;

在plsql里面修改了数据，请记得提交事务 

插入日期型

insert into angel_msky_user (activate_status,mobile,activation_code,activate_generate_time) values (1,13658291745,123456,to_date('2007-1月-1','yyyy-Mon-dd'));