To Set Up Database Users

You can use the FDO User Manager utility that comes with AutoCAD Map 3D toolset to set up database users for Oracle, SQL Server, and MySQL.

To manage database users and accounts

1. Start FDO User Manager.

   By default, FDO User Manager is located in \Program Files\Autodesk\AutoCAD Map 3D 2022\bin\FDO\. To start it, either double-click FdoUserManager.exe in File Explorer or enter FdoUserManager at a command prompt. (To invoke FdoUserManager from any prompt, add its directory to your path.)

2. At the Choose a Provider menu, enter the digit that corresponds to your FDO Provider and press Enter.
3. Enter each connection parameter when prompted and press Enter.

   For example, enter the required service name and username/password. For more information, contact your database administrator.

4. After you are connected, follow the instructions on the screen.

   If you are adding a user, enter the user name and password.

   New users you create with this utility automatically have the roles and privileges required by the AutoCAD Map 3D toolset FDO functionality. However, FDO User Manager allows you to grant some additional privileges. Use commas to separate the role names, with no spaces. You can enter ? to see a list of roles. To verify the roles after you add them, select List All Roles And Privileges Of A User.

5. When you finish, enter 0 (a zero) to exit FDO User Manager.