--新建用户create user test identified by testdefault tablespace test_datatemporary tablespace test_temp;--赋权grant connect,resource to test; (dba:包含大部分的权限)