ADS: Add/Modify Users + Interface

[Former Member]

Hello,

I was introduced recently to the AD technology, and I now have to use it to interface with a legacy software on Win 7. I have successfully followed the advantagezone development help files in order to install both the ADS and the ODBC driver. A few questions remain, the first of which being the following: How does one change the password of a user/add a user?

I was unable to find any documentation regarding this matter. Could you point me to the relevant documentation or provide me with the command necessary to do so via command line?

Also I was wondering if there were any sort of GUI to manage the ADS, like MySQL has with PHPMyAdmin or the MySQL workbench.

Thanks for your help!

Cheers,
Philippe

[joachim_drr · Accepted solution]

There's a tiny little tool called Advantage Data Architect (ARC) to administer Databases. Users and Passwords can be modified using ARC or using SQL:

EXECUTE PROCEDURE sp_CreateUser('User1','password','comment');

EXECUTE PROCEDURE sp_ChangeCurrentUserPassword('oldpassword','newpassword');

[Former Member · Accepted solution]

ARC also includes a command line query tool called "asqlcmd.exe".