Password Question ?

[Anh_Tran]

Hi All,

Password question comes to me now . I have several passwords for several departments . Let's say department A password is A, department B password is B. To check each department A is A , I have to create a new record , I can not use a global field. Is it the right way? Since the second people come , it will change the password for whole file. Then From First file password is A, he can go to see second file which has to keep the password A for further purpose. Let's say password A can go to other database, password B can go to different database...something like that. In order to keep password A, do I have to create a new record. I don't want to create new record to check password since it is for browse or other purpose.

Somebody has an idea or example to check password by scripts ...thanks

I really need your help

[LiveOak]

I'm not sure I understood all that, but you don't need to create a new record to check which password someone logged on with. Create a group for each password and give each group unique field access privileges. For example give each group their own global field to which only that group has access (gPasswordA, gPasswordB,...). To detect which group has logged on, attempt to write to each global field (SetField[gPasswordA, some value]) then test to see if the write succeeded. If the write succeeds, the are part of that group.

-bd

[Anh_Tran]

hello Bd...I almost got your point. I am sorry about my English. Let's me give you example so you could help me with it. At the first file, there is a password box. I enter password is " AnhTran". so if the password is "AnhTran", I could go to second file if not I can not go to second file.

Now I am in second file. I can browse and do anything. Now I want to go to third file...in order to go to third file , the password has to be "AnhTran" , if not I can not go to third file.

I could not use one global field to check password and go to each file since there are many people and many passwords .

Can someone help me with this?

Thanks in advance

Anh Tran

I don't want to use first level security access, I like to use script . I don't want to do anything with security. It is just how to script I think but my head is not working to find that easy solution

[EddyB]

Hi,

If I understand what you are trying to do correctly then yes you can use one global field.

Each user has there own set of global fields when they open a hosted database.

So for example:

Global Field is set up: g_Password

You open the database and enter AnhTran into the g_Password field

I open the database and enter EddyB into the g_Password field

Me entering EddyB into the g_Password field will not affect you. This is my Global Field and you have yours.

You can then set a button up with a script to go to the third file:

If["g_Password="AnhTran""]

Open["File3.fp5"]

Else

Show Custom Dialog["Access Denied","You do not have the correct access to open this file"]

End if

Just out of curiosity why do you not want to use FM Security, this is the exact reason for it being there!

Ed.

[Anh_Tran]

Hello EddyB,

Yeah that is what i want but the point is that I try a global field on hosted database but everyone use the same ...not seem to appear that you have yours and i have mine. Maybe I will try tomorrow.

Oh ...my boss want me to do that way so that he can go to that database and change password everytime he needs .... he does not want to open first level security access and go to file...ect to change it ...

I think that the first time you type EddyB then u open second file ...then I go after you . I enter AnhTran ...then we got global field is AnhTran not EddyB.

Am I correct on it? or am I out of my mind?

Thanks

Anh Tran

[EddyB]

OK follow these steps and it should be OK:

Stop hosting the database.

Open the database and clear whatever is in the g_Password field.

Rehost the database.

Everytime someone opens the database now from a client pc the global field will be set to blank, I now have my global field and you have yours.

I think the problem you had is possibly that the global field on the hosted database has an entry in it "AnhTran", evertime a user opens the database, their global field is set to the value of the global as it was when it was hosted.

does that make sense???!

Ed.

[Anh_Tran]

Hello EddyB,

It does make sense. I had that problem before but I could not solve it and now you tell me . Thanks alot EddyB. When you said ...stop hosting the database. It means using the close button dialog right? .. Not stop service right? . If I did not create the g_password field yet and I create it now on hosted database, does it work? What do you think?

Thanks

Anh Tran

[Anatoli]

Stop hosting the database, on Windows you can use management plugin or stop service.

On MacOS close databases or you stop FM server application.

Then open file in normal client and clear global fields.

That way they stay blank until user put something there. Every user has private set of globals.

[Anh_Tran]

Thanks Anatoli

I got your point.

Anh Tran

[Anh_Tran]

Hi All,

I want to know that each time I don't host the file, do I have to clear global field? ....or don't enter data in global field?

Global field on host make you have your and I have mine ....save me big time

Thanks

Anh Tran

[Anatoli]

What you put into global field as host is starting point for users of FM server hosted databases.

Otherwise shared values will be wiped out and replaced with value sitting there since last time -- the starting point.

[Anh_Tran]

Thanks Anatoli,

Anh Tran