①.
赋予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;
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;