SQL comparison question...

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Tue, 11 Nov 2003 09:14:32 -0800
Message-ID: <F001.005D6560.20031111091432@fatcity.com>

This is part of a row-level security implementation:

For some reason the following comparison works but currently it isn't:

  1 SELECT count(*)

  2      FROM global.client_dim a
  3*     WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN)

SQL> /   COUNT(*)

---

         0

SQL> select sys_context('userenv','session_user') from dual;

SYS_CONTEXT('USERENV','SESSION_USER')

---

---

REPORTS_DELTA SQL> select reports_login
  2 from global.client_dim
  3 where reports_login='REPORTS_DELTA';

REPORTS_LOGIN

---

REPORTS_DELTA I thought maybe it was due to hidden characters so I tried:

SQL> select '|'||sys_context('userenv','session_user')||'|' from dual;

'|'||SYS_CONTEXT('USERENV','SESSION_USER')||'|'

---

---

|REPORTS_DELTA|
SQL> select '|'||reports_login||'|'
  2 from global.client_dim
  3 where reports_login='REPORTS_DELTA';

'|'||REPORTS_LOGIN||'|'

---

|REPORTS_DELTA|
...that doesn't appear to be it.

any ideas?

Thanks for any help!

Chris

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chris Stephens
  INET: ChrisStephens_at_affina.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Nov 11 2003 - 11:14:32 CST