Concepts and Architecture Interview Question:

Explain what is remote login user and local user in database? And sid is used when user want to login as local user and Glodal database name is used when user wants to login as remote user..
What does it mean?

Submitted by: Administrator

When you have distributed environment,you may access one database from other.This is normally done via db link.So lets say you have flight database and customer dabatabase.Now from customer database you intend to access flight database then you have to create a database link in customer database providing the login credentials for flight database which would mean that you are mentioning the user name(say flight_admin) of flight database in customer database.Hence the remote user(in this case flight_admin).You may require to mention the domain name in the definition if the domain of both the databases are different else its ok.Local user,as the name suggest is the local user of the database residing within that database.
Submitted by: Administrator