Manage

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

Published: 04 Jan 2006

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

SearchDataManagement

Cloudera adds data engineering capability to enable DataOps

Big data vendor Cloudera is looking to help data engineers use its platform with a new service that brings more power and ...

3 growing applications of AI in data management

There are plenty of ways AI can augment data professionals throughout the data pipeline, from sifting through large data sets for...

Key steps in the feature engineering process

Feature engineering is key to machine learning algorithms. Read on to learn how those features are created and chosen to increase...

SearchBusinessAnalytics

Emotions analytics helps Hotels.com connect with customers

While traveling has been halted for most of us, marketing efforts in hospitality still go on, and one way to sharpen those ...

ThoughtSpot IPO probably still a year away

After hiring a CFO for the first time and making changes to the way it reports revenue, ThoughtSpot is positioning itself to go ...

Power BI platform adds data storytelling capabilities

In its ongoing attempt to extend the reach of analytics to more users, Microsoft, during its virtual user conference, unveiled a ...

SearchSAP

In a time of crisis, S/4HANA implementation strategies shift

During a pandemic, organizations may consider pausing a major project like an S/4HANA migration, but experts believe they can use...

SAP Digital Boardroom helps Parkland Health manage pandemic

Parkland Health managed a surge of cases caused by the COVID-19 pandemic by using data analytics based on SAP Analytics Cloud and...

Real-life look at SAP intelligent RPA uses, benefits, limitations

SAP intelligent RPA works with the SAP ecosystem to help automate time-consuming processes. Learn what intelligent RPA is, how ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

How IT can deal with challenges of a move online post COVID-19

What will the long-term effects be of COVID-19 on the IT industry? Early indications show that virtual conferences and ...

How COVID-19 created a demand for COBOL basics

An uptick in COBOL interest stems from its presence in entrenched, legacy government apps, such as unemployment or apps for ...

WebAssembly Hub boosts Envoy filter development

Examine WebAssembly Hub's features, why developers have turned to the portal to share Envoy filters and how it seems to be built ...

SearchDataCenter

A look at the main differences of Bourne shell vs. Bash

Shells help admins run commands from the keyboard to the OS. Though Bourne shell and Bash are similar, there are differences in ...

6 tools to know for private cloud monitoring and reporting

Cloud reporting helps admins address capacity issues and reduce outages. Effective tools should include role-based dashboards and...

Set your strategy to get the right liquid-cooled data center

As data center rack densities increase, liquid cooling's benefits are becoming more apparent. Before purchasing, IT teams must ...

SearchContentManagement

How businesses can best build a WordPress knowledge base

A WordPress knowledge base can be useful for companies that want an easy-to-use and customizable product with many plugins that ...

Knowledge bases benefit customer service, call center training

Knowledge bases provide call center agents with training documents and answers to frequently asked questions as they continue to ...

Box Shield, mobile app upgrades on the way

Among a slew of coming upgrades, Box Inc. goes after Microsoft's government business with FedRAMP High certification.

SearchHRSoftware

Oracle HCM Cloud gets on-demand pay, internal talent market

Updates to the Oracle HCM Cloud platform include on-demand pay, internal talent marketplaces, more automation and an expansion of...

How Trump, Biden see automation and AI

The impact of automation and AI on the U.S. workforce has been a longstanding issue in presidential politics. That may be true ...

Corporate LMS adoption may come down to donuts

Corporate learning management systems can be popular with employees. But adoption requires planning and maybe a little schtick, ...

Join the conversation

1 comment

Send me notifications when other members comment.

Oldest

[-]

ridharm - 10 Jun 2016 6:49 PM

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.

Dig Deeper on Oracle database design and architecture

How to create an Oracle database link

AWS Cognito makes a mark in mobile app development

Mobile device management checklist

Managing linked server security in SQL Server

Join the conversation

1 comment

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.