Oracle创建用户并授权

create user zhangsan identified by 123456;        //创建用户并设置密码
grant connect, resource to zhangsan;        //授权zhangsan用户连接权限
grant create session to zhangsan;        //授予zhangsan用户创建session的权限，即登陆权限
grant unlimited tablespace to zhangsan;        //授予zhangsan用户使用表空间的权限
grant create table to zhangsan;        //授予创建表的权限
grant drop any table to zhangsan;        //授予删除表的权限
grant insert any table to zhangsan;        //插入表的权限
grant update any table to zhangsan;        //修改表的权限
grant create view to zhangsan ;         //创建视图权限