Brian -

I thought you were talking about another VPD on top of the standard
access for the domain. The servprov domain is a little different. You
likely won't be able to do away with it. I'm not sure what Oracle
recommends, but perhaps the role set up could be on the servprov domain,
with the VPD as default. If that's possible, you would have to then
utilize various methods of restriction to make sure the servprov only
sees what they should. A few other things to try:

1) Assigning functions to the level in question
2) Action checks that are assigned to the specific servprov's user ID
and will only allow the user to view a shipment if it meets certain
criteria, i.e. the servprov's ID. If you go that route, the sql needs
to be efficient so there is no performance degradation.
3) I'm not sure how you've modeled your screen sets, but I would think
you would be able to accomplish servprov shipment restrictions by
utilizing the default tab of the screen set to return only specific
results based on the servprov ID. The downside is that the servprov
would require their own screen set.
4) menu and manager layout modification
5) xsl screen modification

There are watch outs for those suggestions, but they are effective. I
would definitely check out the sql statement per Dan's recommendation
first.

Let me know if you need further help.

Regards,

Marnie


-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailtowner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Brian Steemson
Sent: Monday, February 04, 2008 1:44 PM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: RE: Direct SQL Updates (DSU's) Slow with VPD

Hi Marnie

Thanks for the feedback.

I'm not completely familiar with VPD but we haven't done much more than
the standard domain security. We only have one main domain along with
Public and Servprov.

I guess I have a couple of questions then.

Can we switch of VPD and still get the Servprov restrictions ie. so
service providers can only see there shipments?
Can you give some hints on what approach you've used? We are
restricting users via menu and screen set restrictions?

Rgds
Brian Steemson
CSC/GTS (Wollongong)
ph. 0405 537 675

Please consider the environment before printing this e-mail.

CSC Australia Pty Limited; Registered Office: 5B/26 Talavera Road,
Macquarie Park NSW 2113 Australia; Incorporated in Australia. ACN: 008
476
944

This is a private message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. Note: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose.





<Marnie.Schultz@k

raft.com>

Sent by:
To
owner-otmsig@solu <otmsig (AT) solutionbeacon (DOT) net>

tionbeacon.net
cc



Subject
05/02/2008 01:43 RE: Direct SQL Updates (DSU's)
Slow
AM with VPD





Please respond to

otmsig@solutionbe

acon.net









Brian -

I agree with Dan. We at Kraft have experienced a similar issue, but
have been successful with a different approach to security. Can you tell
me a little about what you're trying to do with your VPDs?

Regards,

Marnie Schultz
Kraft Foods Global, Inc.
60 285-6229
Marnie.Schultz (AT) Kraft (DOT) com


-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailtowner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Dan Sedore
Sent: Monday, February 04, 2008 7:44 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: RE: Direct SQL Updates (DSU's) Slow with VPD

Very much could be because of the VPD. You can turn on SQL logging to
see the resultant SQL statement.

Dan

-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailtowner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Brian Steemson
Sent: Monday, February 04, 2008 4:58 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Direct SQL Updates (DSU's) Slow with VPD


Has anyone had problems with direct sql updates run through an
automation agent?

We have examples which run fine in SQL developer but when the same SQL
is run through automation it runs very slowly, these seems to be related
to VPD security?


Brian Steemson
CSC/GTS (Wollongong)
ph. 0405 537 675

Please consider the environment before printing this e-mail.

CSC Australia Pty Limited; Registered Office: 5B/26 Talavera Road,
Macquarie Park NSW 2113 Australia; Incorporated in Australia. ACN: 008
476
944

This is a private message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. Note: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of e-mail for such purpose.



You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution of issues and topics related to Oracle Transportation
Management. If you do not want to receive future mail from the list,
send email to majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!


You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution of issues and topics related to Oracle Transportation
Management. If you do not want to receive future mail from the list,
send email to majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!


You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution of issues and topics related to Oracle Transportation
Management. If you do not want to receive future mail from the list,
send email to majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!



You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution of issues and topics related to Oracle Transportation
Management. If you do not want to receive future mail from the list,
send email to majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!


You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!