授权语句

--同义词删除
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 '更新人';