Q
Manage Learn to apply best practices and optimize your operations.

How to create a database link with an OS Authenticated user?

How to create a database link with an OS Authenticated user?

How to create a database link with an OS Authenticated user?
Unfortunately, there is no command in Oracle that will let you do something similar to the following:
CREATE DATABASE LINK db_link_name IDENTIFIED EXTERNALLY ....;
The reason that you cannot create a database link with OS authentication is that you will be accessing a remote database running on a different server that you have not authenticated to. However, that does not mean that a user local to your database cannot connect to the remote database with a database authenticated user (using a userid and password).

Dig Deeper on Oracle database design and architecture

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Though, it's not recommended but you can certainly do it.
You can create by altering users as: alter user ops$oracle identified by myPasswordString;
Then you can create database link as you do with normal user.
Cancel

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close