授权语句

--同义词删除
drop PUBLIC synonym BBEOA_BUTTONS;
drop PUBLIC synonym BBEOA_PAGE_BUTTONS;
drop PUBLIC synonym SEQ_BPAGEBUTTON_ID;
--取消授权
REVOKE SELECT,INSERT,UPDATE,DELETE on bbeoadata.BBEOA_BUTTONS from bbeoaopr,bbeoacde,r_bbeoadata_dml,bbeoaetl;

REVOKE SELECT,INSERT,UPDATE,DELETE on bbeoadata.BBEOA_PAGE_BUTTONS from bbeoaopr,bbeoacde,r_bbeoadata_dml,bbeoaetl;

REVOKE ALL on bbeoadata.SEQ_BPAGEBUTTON_ID from bbeoaopr,bbeoacde,r_bbeoadata_dml,bbeoaetl;

--删除序列和表
DROP SEQUENCE SEQ_BPAGEBUTTON_ID;
drop table BBEOA_PAGE_BUTTONS;
drop table BBEOA_BUTTONS;
--授权
grant select, insert, update, delete on BBEOA_PAGE_BUTTONS to BBEOACDE;
--新建同义词
CREATE PUBLIC SYNONYM BBEOA_BUTTONS FOR bbeoadata. BBEOA_BUTTONS;
--建表
CREATE TABLE BBEOA_BUTTONS
(
BUTTONID NUMBER(10) CONSTRAINT nn_bbeoa_buttons_buttonid NOT NULL,
SHOWNAME VARCHAR2(100),
ACT VARCHAR2(50),
DESCRIPTION VARCHAR2(100),
BUTTIONTYPE VARCHAR2(1),
FLAG VARCHAR2(1),
created_by VARCHAR2(100) CONSTRAINT nn_bbeoa_buttons_created_by NOT NULL,
created_date DATE DEFAULT SYSDATE CONSTRAINT nn_bbeoa_buttons_created_date NOT NULL,
updated_by VARCHAR2(100) CONSTRAINT nn_bbeoa_buttons_updated_by NOT NULL,
updated_date DATE DEFAULT SYSDATE CONSTRAINT nn_bbeoa_buttons_updated_date NOT NULL,
CONSTRAINT PK_BBEOA_BUTTONS_BUTTONID PRIMARY KEY (BUTTONID) USING INDEX TABLESPACE bbeoaidx
);
comment on column BBEOA_BUTTONS.BUTTONID
is '按钮id';
comment on column BBEOA_BUTTONS.SHOWNAME
is '按钮显示名称';
comment on column BBEOA_BUTTONS.ACT
is 'EOA中的act';
comment on column BBEOA_BUTTONS.DESCRIPTION
is '按钮备注';
comment on column BBEOA_BUTTONS.BUTTIONTYPE
is '按钮流程类型';
comment on column BBEOA_BUTTONS.FLAG
is '是否有效';
comment on column BBEOA_BUTTONS.CREATED_DATE
is '创建日期';
comment on column BBEOA_BUTTONS.CREATED_BY
is '创建人';
comment on column BBEOA_BUTTONS.UPDATED_DATE
is '更新日期';
comment on column BBEOA_BUTTONS.UPDATED_BY
is '更新人';