Friday, 18 July 2014

Map Oracle industry model - Mapsys/Mapmain password

The ordinary Map user needs to know the password of the mapsys or mapmain user in order to connect to Oracle:

Map - Log in dialog box for Industry Models
We are not able to log in using the mapmain user - Map just gives us an error message back. So we need to let users connect via mapsys. Mapsys is a quite powerful Oracle user - we don't want to give username and password to a normal (Map) user (even if it were the mapmain user).

Additionally we have two databases - a production one and a test one. Users need to be able to connect to either of them. Here is how we do it without handing over the passwords:

Map - username and connection details for the login dialog box (command: _mapdbconnect) are stored locally. All details are saved in an XML file. Connection details comprises Oracle database name, mapsys/mapmain user name and password (encrypted).

We have created two xml files - one with the details required to connect to the production database, the other one with the details required to connect to the test database.

There are two desktop shortcuts to fire up Map. A script copies the machting xml file from the network drive to the local folder before Map gets started:

copy SYSTEM.config.mapsys.proddb "C:\ProgramData\Autodesk\AutoCAD Map 3D 2013\R19.0\deu\Settings\SYSTEM.config"
cd /D "C:\Program Files\Autodesk\AutoCAD Map 3D 2013\UserDataCache\"
start "" "C:\Program Files\Autodesk\AutoCAD Map 3D 2013\acad.exe"  /product ACAD /language "de-DE"

The Map user finds all the details for the Login-dialog box filled in already - all he or she needs to do is to enter the personal password. For the user the process is transparent.

Map 2013, SP2

1 comment:

  1. please note - the /product switch is set to ACAD but actually Map is used, so it should be /product MAP instead. At least for us (currently on Map 2013) it doesn't seem to matter that we start the application with ACAD.