Hi Darren

The only way is to create a logon trigger with alter session.
Make sure the user have the alter session privilege
DO NOT do the trigger active for every user!!! ONLY the one
that really needs it.

Just for your information: Indexes are ONLY used with nls_sort=binary
and will be discarded if you set it to binary_ci.
This means that you have to create FBIs for all indexes that you
need.

Regards

Måns


-----Original Message-----
From: Darren Nye [mailto:oracledba-ezmlmshield-x8803743.[Email address protected]
Sent: Tue 2/27/2007 15:05
To: LazyDBA Discussion
Subject: case insensitive!

hello there, I really need to get oracle to perform case insensitive searches,

I know that if you type

alter session set nls_comp=ansi;
alter session set nls_sort=binary_ci;

then it will perform case insensitive searches, but that's only for that current session, is there a way to alter it for a particular user?

please help ive been stuck on this for hours!

thanks


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page