I wanted to use MySQL for storage of login information. Then I will have multiple services (RADIUS, Proxy, etc) checking against the information.
Is there a way to make a master table that will have all the information that is needed, then have a bunch of child tables that have the redundant information from the master table, however, only for the particular service. For example I want a table that only has login that is allowed to use the Proxy included, so the proxy looks at only that table, instead of the master table.
Which so far doesn't seem out of reach, however, I would like the children table to update passwords, etc when ever they change on the master table, so I only have to update the master table.
I think I could do what I need if there was a way to save query, so that when the Proxy server looks it thinks its a table and runs check against the results of the preloaded query.
Hopefully I explained what I wanted clearly enough.