Oracle角色和权限设置

①.   赋予hoperun权限  ---增删改查权限,创建存储过程
    a.  连接权限:grant connect to HOPERUN;
    b.  同义词权限:grant create any synonym to HOPERUN with admin option;
    c. 增加权限 grant insert any table to HOPERUN with admin option;
    d. 存储过程权限：
    grant create any procedure to HOPERUN with admin option;
    grant create procedure to HOPERUN with admin option;
    grant execute any procedure to HOPERUN with admin option;
    grant debug connect session to HOPERUN with admin option;
    grant debug any procedure to HOPERUN with admin option;
    触发器权限：
    grant create any trigger to VL910DTA with admin option;
②.   Tools 菜单下面:Kill Sessions :  alter system kill session '202,2695';
③. 开通dblink权限
    select * from user_sys_privs where privilege like upper('%DATABASE LINK%'); 
    grant create public database link to crpdta; 
      grant create public database link to proddta;  
④. --创建表空间
create tablespace imark
datafile 'E:\oracle\product\10.2.0\oradata\orcl\imark.dbf' size 500M
autoextend on next 100M maxsize unlimited logging   
extent management local autoallocate
segment space management auto;
--创建用户
create user imark              --创建用户名
identified by "imark"          --创建密码
default tablespace imark      --默认表空间
temporary tablespace TEMP     --临时表空间（默认的）
--赋予管理员权限
grant dba to imark;