Modifying Passwords with a script

[SuperG]

I was wondering if it was possible and how to do it if it was, to Modify the master password and add auxilliery passwords in a script. I know to do it individually I would restructure them, however with the number of tables I wish to modify it would require nearly two straight days of restructuring.

My ideal solution would be a script to grab all of the tables within an alias and restructure them one after the other with the exact same structure and indexes but modify the Master and auxilliery passwords.

Any ideas would be greatly appreciated.

Thank you.

Glenn

 

[NotAllThere]

Tables can be password protected and unprotected using the table methods:
protect(const password String)
unProtect(const password String)

These methods set/remove master passwords.

Auxiliary passwords may be added using the restructure() method with the setStruct parameter. See also enumSecStruct() to obtain the existing security structure.

Small caution: I have found, through experience, that the restructure() method sometimes fails, particularily if called with complex restructure operations. However, the above usually works ok.