CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

how to match row security in deub log?

edited Nov 21, 2013 5:45PM in CNC, DB and Operating System - JDE1 (MOSC) 3 commentsAnswered
Hi, wondering if row security applied as below : 

*all company 0001 00609  n n n n  co

*all company 0611 00998  n n n n  co

 Would it be reflected in debug log as  below lines ?

  SELECT  *  FROM CRPDTA2.F0012  WHERE  ( KGITEM = 'ICH' AND KGCO = '00000' )  AND  ( KGCO NOT BETWEEN '00001' AND '00609' AND KGCO NOT BETWEEN '00611' AND '99998' ) 
  ORACLE DBFetch conn=058D47E8 requ=07EB9E58 maxrows=100 
   Incremented JdbCacheRecord count to 12 
   Fetched the record 
   Entering JDB_FetchKeyed (hRequest 07FCC548) 
   ORACLE DBInitReq conn=058D47E8 requ=07EBAF60 JDEDBC (ORCL) new [ 57] 
   SELECT  *  FROM CRPDTA2.F0901  WHERE  ( GMMCU = '         620' AND GMOBJ = '300600' AND GMSUB = '        ' )  AND  ( GMCO NOT BETWEEN '00001' AND '00609' AND GMCO NOT BETWEEN '00611' AND '99998' )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center