Oraclecreate user DEVICECLOUD
identified by DEVICECL
default tablespace DEVICECLOUD ----------------这个DEMO与上面的表空间对应
quota 10m on DEVICECLOUD
temporary tablespace temp ;
------------------------给新创建用户权限，要不进不去或者不能操作
grant create session,create table to DEVICECLOUD ;
grant resource,connect to DEVICECLOUD ;
------------------------其他权限
grant connect to DEVICECLOUD ;
-- grant dba to DEVICECLOUD ;
-- Grant/Revoke system privileges
grant alter session to DEVICECLOUD ;
grant create any directory to DEVICECLOUD ;
grant create any procedure to DEVICECLOUD ;
grant create any sequence to DEVICECLOUD ;
grant create session to DEVICECLOUD ;
grant create synonym to DEVICECLOUD ;
grant create table to DEVICECLOUD ;
grant create type to DEVICECLOUD ;
grant create view to DEVICECLOUD ;
grant select any dictionary to DEVICECLOUD ;
-- grant select any table to DEVICECLOUD ;
grant unlimited tablespace to DEVICECLOUD ;
请高人指点一下
