Setting up a default support user

[avianmanagement]

Can we programmatically add users to the system rather than having to use the user workspace ?

The reason I ask is that in my vfp apps i automatically add a user named support and a password that I know.

That way if I have to remote into a clients system I can always log in.

The sttartup code checks for thsi user and if it is not there the code adds it, if the user has changed the support password the startup code puts it back to what it was before.

This is very useful for support staff.

[barrymavin]

Can we programmatically add users to the system rather than having to use the user workspace ?

The reason I ask is that in my vfp apps i automatically add a user named support and a password that I know.

That way if I have to remote into a clients system I can always log in.

The sttartup code checks for thsi user and if it is not there the code adds it, if the user has changed the support password the startup code puts it back to what it was before.

This is very useful for support staff.

Yes of course. The table is system!sysroles.

The password uses the built-in md5() function to encrypt it.

In Lianja you can access tables across databases using the database!table notation.

[avianmanagement]

Brilliant, thank you