Forum Stats

  • 3,826,359 Users
  • 2,260,635 Discussions
  • 7,896,916 Comments

Discussions

Insufficient privileges while creating database link

User_4CGCS
User_4CGCS Posts: 8 Employee
edited Jun 8, 2022 11:29AM in SQL & PL/SQL

Hi I have created a apex instance in oracle cloud, now from this apex I am trying to create a database link, but its showing me the insufficient privileges error. I tried giving all the role grant to this user from the database which is provisioned while creating the apex, I also ran the command separately " GRANT CREATE DATABASE LINK TO USERNAMEHERE " from the autonomous db as admin, still I am getting same error:

This is the command I am running:

CREATE DATABASE LINK horus_ro

CONNECT TO XXXX IDENTIFIED BY XXXXX

USING

'(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)

(HOST=xxx.oraclecorp.com)

(PORT=1521))

(CONNECT_DATA=(SERVICE_NAME=xxx.oraclecorp)))';

Tagged:

Answers