GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle

 Print  |  
Question:  Identifies Globally

Answer: While creating a new user we set his password as identified globally, what does it mean?


December 12, 2008 11:03:26 #1
 Paramjeet Singh   Member Since: November 2008    Total Comments: 1 

RE: Identifies Globally
 

We dont set user's password as "identified globally". We write "identified globally" to decide user's scope.

Details:

In Oracle, we can create user in three ways:
1. local user
2. external user
3. Global user

Different commands to create these users:
We create local user as:
create user user_name identified by password_string........;

We create external user as:
create user user_name identified externally as .......;

We create global user as:
create user user_name identified globally as .......;

Difference in the scope of these users:

local user always requires a password to log in to oracle, no matter what.

External user will not require any login password as local user does.
Such a user will be authenticated by operating System. Means: If you can log in to operating system, you can use oracle too.

GLobal user will also not require any login password as local user does.
Such a user will be authenticated by a directory service .. like OID (Oracle Internet Directory). This service is used when we have enormous number of users who use oracle and we want to maintan them from one place centrally.

I think this much information is enough for interview perspective.
If you want to understand it in details.
Visit oracle documentation available online.
You can visit this : http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8003.htm#SQLRF01503


Thanks,
Param
oraclescoracle dot blogspot dot com


     

 

Back To Question