Results 1 to 7 of 7

Thread: Securing UTB

  1. #1
    Senior Member
    Join Date
    May 2003
    Location
    Minnesota
    Posts
    121

    Securing UTB

    Is there an easy way to secure users out of UTB, or the data that they can see in UTB?

    We run on an AS/400 and what we do is have different Database user profiles that are used to give a user a JOBQ but also could be used to secure them out of specific files (Such as HR data) But now we are finding a need to secure them out from even seeing any PROD data... I was hoping for a way that doesn't involve me changing all the file security for the proddta lib.

    Any ideas or examples of how you do it, would be great!!

    Nick

    One World XE Update 7 SP22_Q1
    Enterprise = AS/400 V5R2 Running Mimix for HA
    Deployment = SQL Server 2000 SP2
    Clients = 20 FAT Win2K SP3, Thin Win2k SP3 Citrix XP FR3

  2. #2
    Member Soul Glo's Avatar
    Join Date
    Jul 2001
    Location
    Austin, TX
    Posts
    866

    Re: Securing UTB

    Since UTB is an external call application you can secure it in security workbench for specific users or groups of users.
    EnterpriseOne 9.0, 9.2 TR. 9.2.x
    iSeries DB2 V7R1, Windows, Linux
    WebLogic 12c HTML Servers Win. 2016, Linux

  3. #3
    Senior Member
    Join Date
    May 2003
    Location
    Minnesota
    Posts
    121

    Re: Securing UTB

    Thank you. I found that by using the menu gh902 on the external calls screen.

    Now my next question is, can you secure out what Data sources users / groups can select from UTB?

    Thanks!
    One World XE Update 7 SP22_Q1
    Enterprise = AS/400 V5R2 Running Mimix for HA
    Deployment = SQL Server 2000 SP2
    Clients = 20 FAT Win2K SP3, Thin Win2k SP3 Citrix XP FR3

  4. #4
    Senior Member dan_richards's Avatar
    Join Date
    Jun 2001
    Location
    LaLa Land
    Posts
    415

    Re: Securing UTB

    You would have to apply row level or column security on the tables in question.
    Releases: Xe - 9.0
    DB: SQL 2000, SQL 2005, Oracle 8i - Oracle 11g
    JAS: WAS5, WAS6 & OAS
    Thin Client: Metaframe XPe FR4, XenApp Server
    Oracle Certified CNC

  5. #5
    New Member
    Join Date
    Oct 2002
    Location
    South Africa
    Posts
    16

    Re: Securing UTB

    You can also apply Application security to P98TAM. This is the search window within UTB. Even though it is classed as an external application it still adheres to JDE security.
    JBee

  6. #6
    Member
    Join Date
    Aug 2001
    Location
    OR
    Posts
    690

    Re: Securing UTB

    As suggested, to secure users out of UTB, use the Security workbench type 'External Call' security. For seeing rows of data, you need to use the workbench 'Row' Security. UTB uses the Row security just like any application/report to filter records.
    Jean Driscoll
    Emerald Cube Solutions
    Quest Technology SIG
    Senior AS/400 and CNC support

  7. #7

    Re: Securing UTB

    You can restrict Data Source by using your Sign-On Security
    Regards

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.