1.无需密码,以系统管理员身份登录
2.创建用户以及表空间:
create user zhang identified by zhang;
grant create session, connect,resource ,dba,EXP_FULL_DATABASE to zhang;
create temporary tablespace clear_temp
tempfile 'D:/oraclexe/oradata/zhang/zhang_temp.dbf'
size 32 m
autoextend on
next 32 m maxsize 4048m
extent management local;
create tablespace clear_data
logging
datafile 'D:/oraclexe/oradata/zhang/zhang_data.dbf'
size 32 m
autoextend on
next 32 m maxsize 4048m
extent management local;
alter user zhang
default tablespace clear_data
temporary tablespace clear_temp;
3.修改oracle http端口
SQL> exec dbms_xdb.sethttpport(8088);
4.创建用并授予指定表名的部分权限
create user zhang identified by zhang;
grant create session,connect,resorce,dba to zhang;
alter user kanck identified by zhang;//修改密码
//锁定或者解锁用户
alter user account lock/unlock
Create user union_input identified by tltgd;
SQL> grant select,insert,delete,update on gd_union_merchant to union_input;
Grant succeeded
SQL> grant select,insert,delete,update on union_terminal to union_input;
Grant succeeded
SQL> grant create session to union_input;
grant create sequence to union_input;
Grant succeeded
5.创建触发器
create or replace trigger dectuser_tb_tri
before insert on dectuser /*触发条件:当向表dectuser执行插入操作时触发此触发器*/
for each row /*对每一行都检测是否触发*/
begin /*触发器开始*/
select dectuser_tb_seq.nextval into :new.userid from dual; /*触发器主题内容,即触发后执行的动作,在此是取得序列dectuser_tb_seq的下一个值插入到表dectuser中的userid字段中*/
end;
6.创建存储过程