I have a customer who entered his administrator name and password within Developer and did not write the information down. He has now forgotten the password. What is the fastest way to fix this situation and get him up and running again?
1.make a backup of the repository database
2. delete the contents of the table servoy_users using a sql tool
jaleman:
2. delete the contents of the table servoy_users using a sql tool
How do I do this on OS X 10.3?
That depends on which database you use. If you use iAnywhere (as of 2.0 the default database Servoy ships with) you can download the developer edition of iAnywhere from www.ianywhere.com and use Sybase Central (information on using sybase central is in our docs as well as in the sybase docs) to connect to the database.
Pfew… I can login in Security again… I re-installed Servoy Developer and imported the solution again. That did it too
Thanks iAnyway, Jan!
iAnytime!
I just had a little look into Sybase Central, it’s a really nice tool! I even can rename the tables…
freecolours:
I just had a little look into Sybase Central, it’s a really nice tool! I even can rename the tables…
Note that if you rename tables you must restart servoy developer before it can see the changes.
Thanks! I noticed that… other thing about Sybase central is that I would like to be able to change the column type, but I can’t. Is there a possibility to do that somewhere?
delete it and recreate it
Yes, but do I erase the data content in the deleted and re-created column?
yes of course
you can copy the data into a copy table to avoid that.