--drop user readlsbh cascade; --删除用户,慎用
CREATE USER readlsbh IDENTIFIED BY readlsbh
DEFAULT TABLESPACE "LSBH_TBL"
TEMPORARY TABLESPACE "LSBH_TEMP";
grant CONNECT,EXP_FULL_DATABASE,IMP_FULL_DATABASE,RESOURCE to readlsbh;
grant ALTER ANY PROCEDURE,ALTER ANY TABLE,ALTER ANY TRIGGER,CREATE ANY INDEX,
CREATE ANY SEQUENCE,CREATE ANY SYNONYM,CREATE ANY TABLE,CREATE ANY TRIGGER,
CREATE ANY PROCEDURE,CREATE ANY VIEW,DELETE ANY TABLE,DROP ANY SYNONYM,
DROP ANY PROCEDURE,DROP ANY TABLE,DROP ANY TRIGGER,EXECUTE ANY PROCEDURE,INSERT ANY TABLE,SELECT ANY TABLE,UNLIMITED TABLESPACE,UPDATE ANY TABLE to readlsbh;
CREATE USER readlsbh IDENTIFIED BY readlsbh
DEFAULT TABLESPACE "LSBH_TBL"
TEMPORARY TABLESPACE "LSBH_TEMP";
grant CONNECT,EXP_FULL_DATABASE,IMP_FULL_DATABASE,RESOURCE to readlsbh;
grant ALTER ANY PROCEDURE,ALTER ANY TABLE,ALTER ANY TRIGGER,CREATE ANY INDEX,
CREATE ANY SEQUENCE,CREATE ANY SYNONYM,CREATE ANY TABLE,CREATE ANY TRIGGER,
CREATE ANY PROCEDURE,CREATE ANY VIEW,DELETE ANY TABLE,DROP ANY SYNONYM,
DROP ANY PROCEDURE,DROP ANY TABLE,DROP ANY TRIGGER,EXECUTE ANY PROCEDURE,INSERT ANY TABLE,SELECT ANY TABLE,UNLIMITED TABLESPACE,UPDATE ANY TABLE to readlsbh;
--创建同义词 lsbh到readlsbh
create or replace Synonym ReadLsbh.tSkuPlu for Lsbh.tSkuPlu