Results 1 to 2 of 2

Thread: Check Branch Plant security on the fly (BSFN??)

  1. #1
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Cork, Ireland

    Check Branch Plant security on the fly (BSFN??)

    Hi all,

    Is there a BSFN to check if a a user is allowed access to an MCU? Is there a BSFN I can call to check the row security myself?

    I was thinking of doing a select fetch on F00950 using the USER ID and DTAI = MCU to check for a match. Is that simple for super users who can see everything?

    Reason I ask is I am allowing users to type in certain MCUs for Item Branch creation and I need to check that they are allowed access to that branch somehow.
    I've never seen row security in action in an interactive session, so I don't know how it behaves.
    Does it error on the user there and then?


    Last edited by johndanter; 12-06-2017 at 09:50 AM.
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR Unix

  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    NSW Australia

    To check the F00950 you may have to take into consideration the User, any assigned roles (in priority order) and *PUBLIC. Also whether or not exclude or include security is active. Your organisation policies and JDE setup may simplify some of this.

    Row security changes the where clause of the SQL generated by the inquiry. This is done at the system level. I've never seen it coded in an application or UBE. I've never seen a standard BSFN that returns the access to a particular business unit or other data. But that doesn't mean it's not there. I think I remember someone posting a SQL on JDEList that did what you want (or an approximation), but I'm not certain.

    Depending on the application/action it may raise an error at the time or just not return anything. I'm not sure what would happen if you coded (in a custom application/UBE) a "manual" row insert into a table for a business unit and the user running it did not have access to add the business unit. It would be simple to test.

    I believe that there are commercial utilities/reports (probably as part of a suite) available from All Out Security and others, that do what you require.

    If you create your own, I would be interested in the details.
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

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.