Hey!
It's just been brought to my attention that a certain price type was available on the web that shouldn't be. I've removed the web access to it so it is no longer available but I'd like to know how long it has been there and perhaps who was responsible for adding it.
Does anyone know of a way to audit changes made in the security application?
Hi Beth,
The user/PT relationship is stored in TX_PRICE_TYPE_USER_GROUP however it only has 2 columns and doesn't record who or when the relationship was created.
The only other area to look would be in the tables/views in the Master database. The sys.objects view only records when the entire table was created and when it was last modified so no luck there but there may be something in that db. somewhere……
So, failing a place in the Master db, you can find the first order done using this PT/MOS combination by running the following query (and putting in your id numbers):
Select
MIN(order_dt),
a.order_no
from T_SUB_LINEITEM a
join T_ORDER b on a.order_no=b.order_no
where price_type = 'price type id here'
and MOS = 'web mode of sale id here'
Sorry couldn't be of more help here, but hope this give you something to look at.
Natasha
Thanks Natasha!
I'm not seeing that it was successfully used in any orders (thank you for the script suggestion btw!) which is good news.
I would just really like to find out how it got there in the first place!! But perhaps it will be a mystery for the ages....
Thanks again,
Beth