授予对从数据库链接到本地数据库的表的访问权
问题描述:
我目前正处于一个需要我编写SQL脚本以创建本地数据库的项目中。在我的代码中,我创建了一个数据库链接到我创建用户需要的开发数据库。为了让我通过所有单元测试,我需要提供从我的数据库链接访问所需的特定表。当我运行所有单元测试时,唯一抛出的错误是'ORA-00942:表或视图不存在'。我如何从本地数据库链接为用户xxltbpg授予对这些表的访问权限?授予对从数据库链接到本地数据库的表的访问权
下面是我迄今编写的代码:
--Drop Database--
drop database link DEV_LINK;
--Create database link--
create database link DEV_LINK
connect to XXLT
identified by sl6ujy
using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = usnoebsdev64db) (PORT = 1531))(CONNECT_DATA = (SID = DEV))) ';
--Create Users for LWS-
CREATE USER xxlt IDENTIFIED BY laitram;
CREATE USER xxltep IDENTIFIED BY laitram;
CREATE USER xxltbomgenerator IDENTIFIED BY laitram;
CREATE USER xxltcustomerdata IDENTIFIED BY laitram;
CREATE USER xxltcustomerdocuments IDENTIFIED BY laitram;
CREATE USER xxltdashboards IDENTIFIED BY laitram;
CREATE USER xxltengineeringdata IDENTIFIED BY laitram;
CREATE USER xxltinventorydata IDENTIFIED BY laitram;
CREATE USER xxltlogging IDENTIFIED BY laitram;
CREATE USER xxltpricing IDENTIFIED BY laitram;
CREATE USER xxltproductsavedstate IDENTIFIED BY laitram;
CREATE USER xxltpublicapi IDENTIFIED BY laitram;
CREATE USER xxltrodsolver IDENTIFIED BY laitram;
CREATE USER xxltservicedirectory IDENTIFIED BY laitram;
CREATE USER xxltwarehouseleadtime IDENTIFIED BY laitram;
CREATE USER xxltwebconfig IDENTIFIED BY laitram;
CREATE USER xxltwipaudits IDENTIFIED BY laitram;
--Create Users for BPG--
CREATE USER xxltbpg IDENTIFIED BY laitram;
GRANT CREATE SESSION TO xxltbpg;
--Grant access to tables from local database--
答
虽然我正在寻找您的问题,我觉得这个问题已经被问使用这个链接,如果它可以帮助