Prev
Next
Forums Infor / Lawson Platforms S3 Security

Finding drill around tables

 5 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Ari
Veteran Member
Posts: 49
Veteran Member
1/25/2013 8:32 PM
    In order to secure tables used in drill arounds, we have to search the .or files to find the associated tables; has any come up with an easier method to find the tables associated with a drill around?

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    1/25/2013 8:52 PM
      What I've done is run a Fiddler session and then do the drill... the captured Fiddler data will include the table name(s) that you need to secure, or unsecure.
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
      1/25/2013 9:09 PM
        Look for a URL on the left of the Fiddler screen like /servlet/Router/Drill/Erp ...
        Click on that, then move to the right half of the Fiddler screen. Click on the Inspectors tab, and (I like to click on the 'Raw' tabs in both the upper and lower portions of the window) the fileName parameter will identify the table name.
        Ari
        Veteran Member
        Posts: 49
        Veteran Member
        1/25/2013 9:33 PM
          The URL dme lists the key name (ie. EMPSET1...) but not the table name.
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          1/28/2013 8:08 PM
            And using that information, you can determine the table name.
            1) select * from gen.filedef
            where prefix = 'EMP'; # Note: the first 3 char from your example above
            2) rngdbdump -ct gen filedef -f filename prefix -v prefix=EMP
            Jimmy Chiu
            Veteran Member
            Posts: 641
            Veteran Member
            2/4/2013 2:10 PM
              Another way is to use DrillExplorer builtin feature in LSA.