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
[mailto
wner-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
[mailto
wner-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!
Linear Mode
