Jump to content
Sign in to follow this  

Passing primissions between databses?

Recommended Posts

mcsebot    0

I suspect this has been answered before but my searches aren't finding what I need.

I have two databases and I'm linking fields from DB2 to the interface in DB1. I have external authentication going. When user connects to DB1 their asked for authentication for DB2. I don't what them to have access to DB2 and I don't want them to see DB2 as would happen if I were to even give them read only.

I've setup the External Data Source between the two FileMaker databases. What might I be missing? I should be able to display data from other databases without giving the user read access to all the databases. 
I hope you understand what I'm trying to say and thank you for any help.

Where's my Boot-Camp,

Share this post

Link to post
Share on other sites
Wim Decorte    455

Sounds like you did not configure DB2 for external authentication like you have DB1.  If DB1 uses any kind of data from DB2 then it must allow authentication for the same user.

Note that authentication is not the same as authorization.  With authentication you're just establishing WHO someone is.  With authorization you establish WHAT they can do in your database.

You absolutely must authorize the user to DB2 but you can control what they can see and do.

When you say "I don't want them to see DB2", do you mean in the "open remote" dialog?  That's easily fixed and has nothing to do with authorization or authentication.  Just set the file up to be not visible.

Share this post

Link to post
Share on other sites
mcsebot    0

Thank you for the quick reply. I do have some users that need to see DB2 and will be working in it directly. On the server I have "List only the databases each user is authorized to access checked.
If I Authorize each user for read only in DB2 so they can see the contents in DB1 they're all going to see DB2 in the Launch Center.

Is there a way I can provide Authorization at the DB level?  

Share this post

Link to post
Share on other sites
Wim Decorte    455

Authorization is always set at the db level; not sure what specifically you have in mind?

One way to solve the database visibility: set all files to be not visible in their sharing properties.  Then give users a launcher file that opens the main file they work in.

Share this post

Link to post
Share on other sites
mcsebot    0

I'm not explaining this correctly and I don't know how to. Thank you for your feedback. If I happen to figure out a better explanation I'll post it.

Happy Holidays...

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Similar Content

    • By 123
      I have a question about hosting my filemaker database. If I buy a license for 5 people form here: https://store.filemaker.com/filemaker-cloud , will I also need to purchase 5 normal FileMaker 16 Pro Client licenses so people can actually connect to the database? I don't quite understand how this works yet, maybe someone can help me out. Do I get the client licenses with the purchase of a server license? I need 5 people to be able to access it. Thanks in advance,
    • By mvoogt
      I'm thinking of redoing my fm server and upgrading to 16. My users experence a lot of slow down when remote users are connected or when multiple users are in the same layout/table doing data entry. 
      Im hoping setting up a raid 1+0 might solve this. I have a Mac Pro trash can server with 16gb ram. Right now server and the database are stored on the same single ssd.
      should I keep the server app installed on the internal ssd and move the database file to a thunderbolt raid? Is that how I get the most benefit?
      can anyone recommend a great raid controller or point me to a setup recommendation?
    • By Keawe
      I installed supercontainer on my Windows server at aws Amazon. I also installed the companion plug-in. It shows up on Filemaker Pro no problem. But it doesn't show on webdirect. Any idea?
      Here is my configuration:
      - FMS 15, Windows 2016 server. 
      - SuperContainer 2.94, build 9234.
      - I have the companion plugin put inside "..\FileMaker Server\Web Publishing\publishing-engine\cwpc\Plugins".
      - The plug-in I use is "SuperContainer_Companion_Plugin.fmx64".
      P.S.: I will send an email to 360works. But just want to post it here so we can all share the solution. Thanks.
    • By Gnurps
      On two Filemaker Server machines I manage, I cannot get FTPeek to activate. After checking the checkbox, a grey message appears appears stating that the plugin was enabled, but the checkbox is unchecked. 
      I have checked the permissions of the plugins. Both owned by fmserver and group fmsadmin. I have restarted the machines. I have tried Wim's suggestion of installing with server-side script. Both have Java 1.6 installed. Both have the BaseElements plugin installed and successfully enabled.
      Both are running FMS 14.04. One is a Mac mini running Yosemite, with  Core 2 Duo processor and 8gb. Other is a Mac mini running El Capitan with Core 2 Duo and 4gb. 
    • By animation_master
      FileMaker Pro 15 Launch Center connects to our AWS instance with no problem. But then it reports
      No files are currently hosted on AWS instancename.
      Well, there ARE files currently hosted. We access them via WebDirect, so they must be hosted.
      Moreover, when we launch a local copy of the file, FileMaker offers to open the remote copy with
      This file has previously been uploaded to FileMaker Server. Use Hosted Version?
      It even displays the proper address for the hosted file.
      However Use Hosted Version returns this error:
      The file “filename.fmp12“ could not be opened. (Extended privilege disabled)
      So, we created a privilege set that extended privileges for fmwebdirect, fmapp and fmxdbc.
      On the next launch of Remote Version, we got this:
      FileMaker cannot share a file because FileMaker network sharing is turned off.
      So, we turned on ODBC sharing, and on the next launch, we got this:
      FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer.
      I’m going in circles here. Are these errors related? What am I doing wrong?

Important Information

By using this site, you agree to our Terms of Use.