create user TEST identified by "TEST" --创建TEST用户default tablespace USERStemporary tablespace TEMPprofile DEFAULT;grant connect,create view ,resource to TEST;grant unlimited tablespace to TEST;--管理员授权 grant create session to TEST;--授予TEST用户创建session的权限，即登陆权限 grant unlimited session to TEST; Read More
