MDW user list

[PROXI]

Is there a way that I can programmattically make a module or table that is populated by the mdw user/passwords? Right now i have a secured BE database that has around 25 accounts inside and I don't know how to retrieve the passwords. OR!!!!!! I would eventually like to make it so that if they forget their passwords then they can email themselves (using the email that is associated with their name) the password that is in the MDW file. If anyone could help I would appreciate it.

PROXI

 

[VBslammer]

You can get the users, but the PID and Password info cannot be determined. If you forget a password, an Admin can delete it and make a new one, but he can't view the existing one.

The documentation for the [tt]User Object[/tt] says:

  Use the Name property to return the name of an existing user. You can't return the PID and Password properties of an existing User object.

There are some .mda addins that decrypt the mdw file, but the details for decrypting the file are proprietary.


VBSlammer

Unemployed in Houston, Texas

 

[pouggy]

LDBView.exe is a useful utility which is available from Microsoft. Search their KnowledgeBase. It displays users who HAVE and ARE logged into your DB.

Just reflecting on the previous note about Admin deleting a user account. A secure database is not secure if the default Admin account has privileges as any MDW file could then be used to open the database. Admin should have all privileges denied and a separate Administrator ID should be set up with AdminS rights.