Data Selection

Guest

Guest
Hi List,

How can i set up the UBE data selection security? I don't want the users delete or add a new line. Regards,

David

Xe SP13, Enterprise server-AS400 V4R4, Deployment Server-NT4.0, JAS server-NT 4.0
 

lisa_stinebuck

Active Member
David_Hsieh,
Go into the Security Workbench and choose the option on the Exit
Row that reads Processing Options. Here is where you will indicate what
type of processing option security you are placing on the UBE (use the
checkboxes to determine if you want them to be able to make changes,
prompt for values, prompt for version, or prompt for data selection.
(Remember - security in OneWorld uses a "Toggle" affect to turn it on
and off).

Lisa G. Stinebuck
Senior Service Delivery Technician
Logical EBOC Cincinnati
513-412-7950 x1021
lisa.stinebuck@us.logicaleboc.com
 

Guest

Guest
Re: RE: Data Selection

Lisa,

I do want prompt for the data selection since user needs to change the data selection prompt on the screen but i do not want them to delete the data selection line or add another line.

Regards,

David

Xe SP13, Enterprise server-AS400 V4R4, Deployment Server-NT4.0, JAS server-NT 4.0
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: Data Selection

David,
Do you want to apply this restriction generally for UBEs or only for a specific on?
If only for a specific one then is it a custom UBE or an original OW UBE?

Happy Easter Holidays!

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.

lisa_stinebuck

Active Member
RE: RE: Data Selection

David_Hsieh,
In XE go to Security Workbench. Click Processing Options from the
Exit row. Put in the User or System Role you are blocking security for.
Then where it reads "Application" type in the UBE that you are trying to
secure (example: R98403), click Find. Click the + beside Unsecured
Item, you will see the UBE you are securing. Place a check mark in
Change, Prompt for Versions, Prompt for Data Selection. Then highlight
the item under the Unsecured section and drag it and drop it under the
Secured section. Click Find again. This will refresh the item with the
changes you are making.
Once you drag and drop you should see Y and N under the different
security areas.
Test the security.

Lisa G. Stinebuck
Senior Service Delivery Technician
Logical EBOC Cincinnati
513-412-7950 x1021
lisa.stinebuck@us.logicaleboc.com
 

Ray Justus

Reputable Poster
David,

You can do this using two UBE's. The first UBE has nothing in it but a blank section with event rules calling the second UBE and sending required processing option information received from the user through a report interconnect. Suppress the output of the first UBE so you won't get a blank page. You must set up a data structure in the second UBE for the report interconnect. In the second UBE's data selection, set your table or view columns or other required values equal to the data item in the report interconnect. The version for the second UBE should be set up as blind execution and with security that precludes user access. You can give me a call if you want to discuss this in more detail.

Ray W. Justus
Kitchell Corporation
1707 East Highland Avenue, Suite 100
Phoenix, AZ 85016-4679
(602) 631-6157
mailto: rjustus@kitchell.com

Hi List,

How can i set up the UBE data selection security? I don't want the users delete or add a new line. Regards,

David

Xe SP13, Enterprise server-AS400 V4R4, Deployment Server-NT4.0, JAS server-NT 4.0

--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=9097
 

Guest

Guest
Re: RE: Data Selection

I want to apply this to all the OW's UBE data selection screen.

Xe SP13, Enterprise server-AS400 V4R4, Deployment Server-NT4.0, JAS server-NT 4.0
 

stevenlais

Member
Hi David,

in the Work with Batch version- available versions, you can select the
security level:
0 No security
1 medium security
2 medium to full security
3 full security
I had only used the medium security where user cannot changed the data
selection and sequencing. They can only copy the version to their own. The
rest of the security need to be explore by you. I bet 2 or 3 is more
stringent.
 

Adrian_Chimirel

Legendary Poster
David,
As far as I understood from your request (even if it doesn't make a lot of sense to me), you want the user:
a) to be able to CHANGE operands and operators, but
b) to keep the existing number of operations in the Data Selection.
Is that right?

LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: Xe SP15, Oracle 8i
RS/6000, Citrix
 

Guest

Guest
Adrian,

On the data selection screen, I don't want user be able change the operator, left operand and comparison column. The only thing they can change is the right operand. In addition I don't want user be able to add another selection line. regards,

David

Xe SP13, Enterprise server-AS400 V4R4, Deployment Server-NT4.0, JAS server-NT 4.0
 

Adrian_Chimirel

Legendary Poster
Now I got it, David! Better ask clarifying questions BEFORE answering, no_matter_what!
As Bill Williams puts it, let the user select data in the processing options and make the change in event rules.
Allow me expand his thread with three more words:
a) The general idea is to use the Processing Options (passed values in a few lines of ER code, based on the system function Get User Selection) and NOT the standard Data Selection
b) This means you have to create another DSTR and
c) Attach it to your UBE and
d) Pass the PO values to intermediate variables and, finally
e) Use the variables within User Selection system function.


LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: Xe SP15, Oracle 8i
RS/6000, Citrix
 

Zoltan_Gyimesi

Legendary Poster
David, Adrian

As David answered me that "I want to apply this to all the OW's UBE data selection screen", so Adrian, your great solution is not a solution for him in general.

I am affraid, there isn't any general solution for David.
The Selection window is not a OneWorld object and supposly reside in one of the OneWorld system DLL, so there isn't any source code for it.

David, maybe you can try to post your issue to the Response Line, but do not hope to much in a positive answer.

Sorry,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Top