How To Assign Particular NLS_CALENDAR To Particular User
- I use Data Base 10g .
- We have One Data Base is Called (orcl) and We have Two Oracle User are Called (ghan) and (jed) .
- In The Oracle User (ghan) and (jed) The Default Value For NLS_CALENDAR parameter for nls_session_parameters is Gregorian .
SQL> select * from nls_session_parameters;
PARAMETER VALUE
--------------------------- -------------------------------
NLS_LANGUAGE AMERICAN
NLS_CALENDAR GREGORIAN
----------------------------------------------------------------------------------------------------------------------------
** The Problems Definition :
How To Assing Two Difference NLS_CALEND To Tow Users In Same D.B
That mean I want to assign NLS_CALENDAR = 'ARABIC HIJRAH' To (ghan) User
And NLS_CALENDAR = Gregorian To (jed) User