I’m hoping someone can help me figure this out. I have a “Messages” database that stores messages between users (this is separate from my User database). I’m wondering how I can make the Messages Database private to restrict access to messages where they are NOT the sender or receiver. In other words, I want to make it so that they are ONLY allowed to view the message database “thing” if they are a sender or receiver for that row/thing. From what it appears, the privacy rules are an all-or-none for the whole database (unless I’m doing it wrong).
Can someone provide some insight? My appreciation in advance.
Thanks for the input, Ed… I have read through this and I’m trying to find videos, but one major thing remains unclear to me. If I have an event database of a bunch of events (to keep it like the example in the manual) that are created by various “creators”, and I set up a rule for for an event, say that the Event Creator is the Current User, will it give access to just that thing/line item/row? I know I can then go more granular with which columns, but my confusion is whether it says to ignore the other events created by other creators. Does that make sense? When I read the manual or watch videos, they seem to make an assumption about this part that I am hoping they go more in-depth on this with… maybe I’m just WAY overthinking it and it’s a simple “Yup, it just looks at that line item for that creator and ignores other creators in that database”.
Sorry, one more thing… do you know why it doesn’t have “Email” as one of the options that if I am trying to make a rule, it doesn’t allow me to choose a user’s email?
When you create a specific rule, it still leaves the default rule for everyone not covered by the specific rule(s) you create. So if you uncheck everything in “Everyone else (default permissions)” then no one will be able to see that datatype unless they are allowed by a specific rule, such as a rule saying that a User can see Events they created.
I haven’t given this much thought because I’ve never had a need to set a privacy rule by an email. I just set it based on the user. My gut guess is it has something to do with the email being a special field that has to be unique. If you really needed the email however (like if you wanted to restrict based on a email’s domain) and aren’t able to access it, you could create a field in Users to hold the email domain, and access that.
I have applied rules and I DO think I was WAAAAAY overthinking it… it appears that when the search criteria applies, it gives access to that ROW… I was thinking about whether it gave or didn’t give access to the entire database.
