Changing Micros 3700 v.5.1 totals with dba

[m3700installer]

Hi!

I need to program SQL procedure for changing the revenue statistics.
Only problem is dba password, can someone provide it?
If you have it, please let me here your contacts.

With regards,
Peter Swan

 

[Moregelen]

1) There are soooo many linked tables that manually changing this is a TERRIBLE idea.

2) Why the hell would you need to do this manually, unless you have untrustworthy intent..?

 

[m3700installer]

Thanks for the answer !
I have couple of stored procedures for doing it.
It was working nice with version 4, but there was upgrade on the site.
I will be very glad, when someone can provide it!

 

[Wildbar]

I think this says it all........

2) Why the hell would you need to do this manually, unless you have untrustworthy intent..?

 

[pmegan]

Exactly, there's no good reason to manipulate sales data behind the scenes.

 

[Moregelen]

Unless you can give an extremely good, credible reason, I don't think you'll find much help here. And even if you did give a good reason, shame on anyone who posts the default DBA password on an open forum.

 

[pmegan]

I wasn't even aware that there was a default dba password when you upgrade from 4.x to 5.x. All of my 4.x installations made me change the dba password before OPS would start, and those passwords carried when the db was upgraded to 5.x. Non-default passwords is a PCI requirement, isn't it?

 

[m3700installer]

Hi!

Thanks for the replies!
Reason is strong, I made one tool for reducing revenue in POS system.
This was one requirement by owners of restaurant to have such thing.
You do not think to leave this password here.
Please, when some one can help me, you can do it trough Elance.
I opened a job there: Link

 

[m3700installer]

Sorry for typos..

 

[pmegan]

Sorry man. Untraceable revenue reduction is something you couldn't pay me to touch. Sounds like tax evasion and that's a kind of trouble I want nothing to do with.

 

[Moregelen]

Ok, yeah, that's a TERRIBLE reason. Sounds fairly illegal too.

And there isn't a default password with upgrades; there is with new installs. Plus there is the 'super secret' micros 'back door'. I know the more recent res four and of course res five won't start with default keys or passwords in place, but I couldn't say for sure about previous versions. They may not be pci but why make it easier. We all do it, but even leaving custom custom is a bad idea. That user has read rights on neatly every table, even some it reaaaally shouldn't.

 

[dynahpointch]

why don't use the WEB Transaction API from RES to reduce the revenue ?

 

[Moregelen]

Anything you can do with that api you could just do from the register. If what you are doing is legit, you can just do it from the register. If you're trying to reduce the numbers without there being any record of it, no way anyone should be helping you do that.

 

[dynahpointch]

because in the DB you can not see what is going on and sounds very illegal.
With the Web Transaction API you can have everything in Journal and it is correctly transfered in every DB Table..

 

[pmegan]

because in the DB you can not see what is going on and sounds very illegal.
With the Web Transaction API you can have everything in Journal and it is correctly transfered in every DB Table..

Right, that's exactly what he's looking to do. He needs the dba password to manipulate totals through SQL rather than going through OPS (or the API). Basically walk through and leave no tracks to cover.

Honestly I can't think of any legitimate (legal) reasons to reduce your reported revenue this way.

 

[dynahpointch]

use the Demo SP_cleartotals to clean up a full day
it is better than nothing.

i'm too i can't find any legal reason to reduce revenue in the DB.
the DBA Password must be set everytime to a customer specific Password.

 

[m3700installer]

Thanks guys for the answers!
Clear totals is ofcourse the funny thing here .
May be I have to tell it to customer.