I am working on editing some content for a database. It was created in FP5 (I think, but I have since saved it as an .fp7 file).

We have hosted the database online, and users can't print reports, so we are contemplating using REMOTE access to the IP.

I logged in as the various users, and it gave me administrative access, regardless of the login that I used. That is a big problem. I was wondering which privileges need to be edited to force the database to use the current privilege and access settings, rather than overriding them.

Thanks,

Ian

Hi Ian,

Each account is assigned to a privilege set. The level of access is controlled by what privileges that privilege set has.

If you wish to test what the privilege set is when someone logs in, use the get(privilegesetname) function in a script or an unstored calc. Hopefully that will help isolate the problem.

One thing you might clarify for us:

We have hosted the database online, and users can't print reports, so we are contemplating using REMOTE access to the IP.

When you say "hosted the database online" and "using REMOTE access", what do you mean? These phrases could have meanings that are different or the same.

Edited February 9, 200718 yr by Guest

Essentially, we have uploaded a hard copy of the database to a website, on which we have server space. It is a database hosting website (it supports FM and SQL servers). It will translate the database into a web based application / into a web based form of the database. People can enter data, and the database is constantly being updated with new information.

By remotely, you have the option within FM to OPEN REMOTE, in which you enter the IP for the server, and if it has rights protection, you are forced to log in. From there, the database is opened from within FileMaker and you can input your information that way. It is convenient for those with FireWall issues blocking web access.

Well, when I logged in as one of the other users, using the REMOTE access from within FM, it gave me free reign for the entire database. We have privileges set up depending on regions (if you are from REGION X, you can only see REGION X data, otherwise it provides NO ACCESS messages). It should function in the same manner as the web based one, but it isn't.

Ian

Does it challenge you for an Account name and password when you connect to it?

Steven

If you are setting up a FAVORITE, and input the IP Address, it will ask for a username and password. We have multiple FM db's at said ip, and according to which username and password you input, it gives an available file. If you click on the available file, and open it, you are logged in with free access.

If I go to LOCAL HOSTS, and give it the internet path to the internet path, it doesn't prompt me for anything. I don't know if there is my ADMIN login cached somewhere within, or if it is just not going to ask for one from anybody.

Ian