时间：2021-07-01 10:21:17 帮助过：5人阅读

MSV31账户登录数据库进行如下操作：

CREATE USER NORTHBOUND IDENTIFIED BY NORTHBOUND  DEFAULT TABLESPACE "TBS_DNINMSV31"  TEMPORARY TABLESPACE "TEMP2"  QUOTA UNLIMITED ON "TBS_DNINMSV31";

GRANT "CONNECT" TO NORTHBOUND; ALTER USER NORTHBOUND DEFAULT ROLE NONE;

GRANT CREATE SESSION TO NORTHBOUND;

GRANT SELECT ON "DNINMSV31"."V_DNDEVICE" TONORTHBOUND; GRANT SELECT ON "DNINMSV31"."V_DNSUBNE" TO NORTHBOUND; GRANT SELECT ON "DNINMSV31"."V_DNPACKAGE" TO NORTHBOUND; GRANT SELECT ON "DNINMSV31"."V_DNPORT" TO NORTHBOUND;

【注】：在用NORTHBOUND登录后查询的时候要在视图前加上DNINMSV31，否则会报表或视图不存在。         例如：         select * from DNINMSV31.V_DNDEVICE;     --可以正常执行

        select * from DNINMSV31.TB_DEVICE where rownum