sql

D:\project\shop_cc_j2ee\src\J2EE\pa18shopcc-dmz.war\daikuan\p\shouxian\js\sxd.js

D:\project\shop_cc_j2ee\src\J2EE\pa18shopcc-dmz.war\product\pshouxian\js\chefangd.js
wap端js-xinjd.js

create table CCDATA.CC_USER_KK_INFO
(
ID_CC_USER_KK_INFO VARCHAR2(40),
USER_NAME VARCHAR2(50) ,
PASS_WORD VARCHAR2(50) ,

CREATED_DATE DATE,
CREATED_BY VARCHAR2(100),
UPDATED_DATE DATE,
UPDATED_BY VARCHAR2(100)
);

comment on column CCDATA.CC_USER_KK_INFO.USER_NAME is ‘用户名‘;

comment on column CCDATA.CC_USER_KK_INFO.PASS_WORD is ‘登陆密码‘;

comment on column CCDATA.CC_USER_KK_INFO.CREATED_DATE is ‘创建时间‘;

comment on column CCDATA.CC_USER_KK_INFO.CREATED_BY is ‘创建人‘;

comment on column CCDATA.CC_USER_KK_INFO.UPDATED_DATE is ‘修改时间‘;

comment on column CCDATA.CC_USER_KK_INFO.UPDATED_BY is ‘修改人‘;

--写主键索引 主键别名 表名 表的主键
CREATE UNIQUE INDEX CCDATA.PK_ID_CC_USER_KK_INFO ON CCDATA.CC_USER_KK_INFO (ID_CC_USER_KK_INFO) initrans 16;
-- 表名 主键别名 表的主键
ALTER TABLE CCDATA.CC_USER_KK_INFO ADD CONSTRAINT PK_ID_CC_USER_KK_INFO PRIMARY KEY (ID_CC_USER_KK_INFO) USING INDEX
CCDATA.PK_ID_CC_USER_KK_INFO;
-- 主键别名
select * from CCDATA.CC_USER_KK_INFO for update;

--同义词
CREATE PUBLIC SYNONYM cc_user_kk_info for CCDATA.cc_user_kk_info;
--角色授权
GRANT SELECT, INSERT, UPDATE, DELETE ON CCDATA.cc_user_kk_info TO R_CCDATA_DML;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_QRY;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_DEV_QRY;

GRANT SELECT, INSERT, UPDATE, DELETE ON CCDATA.cc_user_kk_info TO R_CCDATA_DML;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_QRY;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_DEV_QRY;

sql

原文：http://www.cnblogs.com/kekang/p/4785740.html