CODEWITHSUNDEEP
sqloracle-database
SRVFan
SRVFan

Reputation: 344

Privileges Error - CREATE DATABASE LINK Oracle

I am trying to create a database with to Oracle Database. I used the Oracle Documentation (https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm) to write the below code to initiate the CREATE DATABASE LINK command, but am running into an issue. When I run this code (filling in username and password, of course), I am thrown an ORA-01031: insufficient privileges error.

Here is my code:

CREATE DATABASE LINK ITEMS
CONNECT TO username 
IDENTIFIED BY password
USING 'ITEMS'

Is there an issue with my code, or is it truly a permissions-related issue? How do I tackle this? I haven't used this command before, so I am wondering what needs to be accomplished.

Thank you!

Upvotes: 1

Views: 3640

Answers (1)

MarcelS
MarcelS

Reputation: 112

Do you have the "create database link" system privileg granted to your user account as which you are trying to create?

Upvotes: 1

Related Questions