自己建了个outpbill的用户,在outpbill下建了个outp_card_bill_items表,并改了下授权
create table OUTPBILL.OUTP_CARD_BILL_ITEMS
(
INSURANCE_NO VARCHAR2(18),
SERVICE_CLASS VARCHAR2(10),
PATIENT_NAME VARCHAR2(20),
VISIT_DATE DATE not null,
VISIT_NO NUMBER(5) not null,
ITEM_NO NUMBER(2) not null,
ITEM_CLASS VARCHAR2(1),
CLASS_ON_RCPT VARCHAR2(1),
ITEM_CODE VARCHAR2(10),
ITEM_NAME VARCHAR2(40),
ITEM_SPEC VARCHAR2(20),
AMOUNT NUMBER(6,2),
UNITS VARCHAR2(8),
COSTS NUMBER(8,2),
CHARGES NUMBER(8,2)
)
tablespace TSP_OUTPBILL
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table OUTPBILL.OUTP_CARD_BILL_ITEMS
add constraint PK_OUTP_CARD_BILL_ITEMS primary key (VISIT_DATE,VISIT_NO,ITEM_NO)
using index
tablespace TSP_OUTPBILL
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant select, insert on OUTPBILL.OUTP_CARD_BILL_ITEMS to ROLE_OCASHER;现在的问题是:用system登录后,select * from outp_card_bill_items,结果无此表(我要这样的!)
必须select * from outpbill.outp_card_bill_items才能查到,请问我该咋整
create table OUTPBILL.OUTP_CARD_BILL_ITEMS
(
INSURANCE_NO VARCHAR2(18),
SERVICE_CLASS VARCHAR2(10),
PATIENT_NAME VARCHAR2(20),
VISIT_DATE DATE not null,
VISIT_NO NUMBER(5) not null,
ITEM_NO NUMBER(2) not null,
ITEM_CLASS VARCHAR2(1),
CLASS_ON_RCPT VARCHAR2(1),
ITEM_CODE VARCHAR2(10),
ITEM_NAME VARCHAR2(40),
ITEM_SPEC VARCHAR2(20),
AMOUNT NUMBER(6,2),
UNITS VARCHAR2(8),
COSTS NUMBER(8,2),
CHARGES NUMBER(8,2)
)
tablespace TSP_OUTPBILL
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table OUTPBILL.OUTP_CARD_BILL_ITEMS
add constraint PK_OUTP_CARD_BILL_ITEMS primary key (VISIT_DATE,VISIT_NO,ITEM_NO)
using index
tablespace TSP_OUTPBILL
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant select, insert on OUTPBILL.OUTP_CARD_BILL_ITEMS to ROLE_OCASHER;现在的问题是:用system登录后,select * from outp_card_bill_items,结果无此表(我要这样的!)
必须select * from outpbill.outp_card_bill_items才能查到,请问我该咋整
for outpbill.outp_card_bill_items;