Sign in to follow this  
Followers 0

Passing primissions between databses?

5 posts in this topic

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

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

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

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

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  
Followers 0

  • Similar Content

    • 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?
    • By JeromeMaeckelbergh
      I am working already a few months on my file "DTW-new.fmp12" via the FM-server 15 on my MacBook Pro without problem and suddenly today this file can't be found anymore, although it is still on the server. But it shows that the status is "Closed", so I probably should change this to "Normal" or something else. Sorry for my ignorance, but I can't figure out how to do this. I tried with "open" and "open all", but this doesn't help me.
      Thanks for any help,

    • By Bailey Kessing
      I am running a server script periodically (every hour lets say) which does some database maintenance, uploads some files, etc. I do this on a number of Filemaker Servers (latest server version running on Windows machines) without problems…except for one server. On this server I use scriptmaster to up load some large files into containers as they are generated from scientific instruments. The problem is that the server runs seems to run out of RAM memory after a "few" days. I think this is the only thing that this server does differently than the other 4 servers and feel that this is the problem. My question is…is there a way to "flush" memory used by the plugin or by the FM server. Has anyone else experienced something similar or am I barking up the wrong tree? Thanks. 
    • By Joost Miltenburg
      I am trying to enter a gmail account data for the smtp-data in FMServer. It is however failing on me. I was able to configure the account in my email program with these settings, so what gives ?
      Any takers ?
    • By T_C
      Hi, I've purchased a CloudMail license. I'm going to use it in an environment with 1 FileMaker Server v14 and 12 FileMaker Pro v14 clients.
      The database is already on the server, and the plugin is activated, but I'm not able to use CloudMail functions with a client that doesn't have the plugin installed.
      How can I register the license and use the database from a client?