Remote and Local user

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 ?

Questions by mandygrewal   answers by mandygrewal

Showing Answers 1 - 3 of 3 Answers

cmanan

  • Jul 10th, 2008
 

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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions