--================================
--Oracle 用户、对象权限、系统权限
--================================
建立表空间和用户的步骤:
用户
建立:create user 用户名 identified by "密码";
授权:grant create session to 用户名;
grant create table to 用户名;
grant create tablespace to 用户名;
grant create view to 用户名;
grant resource to
grant connect,resource,dba to 用户;
select * from user_sys_privs;查询当前用户权限
grant connect,resource,dba to 用户;给dba权限
grant connect,resource to 用户;
grant unlimited tablespace to 用户;
grant create database link to 用户;
grant select any sequence,create