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.

I wrote my own passwording system for my Pan business software years ago that logged in the user and recorded the time spent on their session. I use a Main Menu file to control access to all files, none of which can be opened from the Finder. You can include code in the .Initialize procedure to do passwording and control what each user can then do with file.
I am curious ask to why you are leaving Filemaker. I chose ProVUE’s OverVIEW and then Panorama 40 years ago because of unique features that supported the way I needed to run my Produce business. Unfortunately, Pan X does not support many of my critical business needs, especially the Image Objects. I wrote a Pan based UPC symbol file that automatically generates the UPC bar code on the fly as my Pan Inventory file prints the lot numbered labels for my day’s harvest. The symbol is now too blurred to scan my labels at the cash register and I have yet to complete a non Image Object work around after several months. I still can’t get checks print or my P&L file to work and file my 2024 tax returns.

One more thing that I have seen recently is that MacOS seems to be defaulting to Good image generation instead of Best. I bet there is a setting that can change that. I will see what I can find.

I wrote a Pan based UPC symbol file that automatically generates the UPC bar code on the fly…

Greg, have you tried using UPC fonts to generate the barcodes? My experience has been that barcode fonts (like all fonts) output perfectly clearly in Panorama forms which output blurry images. The barcode fonts aren’t free but you only have to pay for them once and can use them forever.

They are fiddly to set up initially but I have no doubt that you’d be able to handle it.