Setting username and password to a database

Hello,
This post is regarding setting password for the database. I have researched the web and help documentation but, still not clear.

I am migrating from FileMaker to Panorama.

In FileMaker database, I can set a username and a password. When I open the database file a prompt asks me for the username and password. Can I similarly have a prompt for username and password when I open a Panorama X database file?

In FileMaker, I can create multiple user names and assign each username a unique password and specific privileges for read, write, or edit access. Are there similar features to Panorama?

Thank you in advance for your guidance on these questions!

Check out this article here, and the other articles referenced by it.

@dave Thank you! Got it! Elegant!

Can we restrict a particular form so that only the Administrator has access, and users or developers cannot open it?

Thank you!

To do that you would have to set up the database so that only the Administrator can use the Standard UI. Among other things, this would completely lock down the View menu for Users and Developers. Then you would have to implement your own custom procedures to regulate how each form can be accessed. Note that if you did this, anyone logged on using a Developer role would not actually be able to develop anything in this database, they would not have access to procedures or form graphics. Only someone logged on as Administrator would be able to work on this database.

@admin Thank you!

I once had FileMaker database which could be accessed through the web. It only allowed the form to be viewed and data to be entered. The user cannot view the entered data. Is this possible with Panorama as well? Thank you

For your original question, it depends on how ambitious you want to get with Panorama. Along with its Account Roles, you can use info(“User”) and your own menus, such as with Custom Menus, to completely control who has access to specified forms. You can also control what the menus offer based on who the user is.

Some reading between the lines is involved on your web form question. It seems that you want a form that someone can complete but they can’t see anything else in the database. That’s definitely achievable. Panorama has extensive web capabilities so, as with any other web site where you might fill in a form, no one has access to anything you don’t want them to see.

For many users, Panorama Server running a web site is the primary use of Panorama.

@JamesCook Thank you very much! It’s good to hear that I have control over the forms. Maybe a project in a year’s time.

Yes, the main aim is to have a database that can be accessed via the web. Good to know that many of the Panorama users use the web-access facility of the Panorama. I will explore this first.