Security setup Question

mw4 · Post by **mw4** » Fri Apr 26, 2019 5:49 am

I have set up dynamic user level security, and I can't figure out what to do next.

I have a users table which has TEAM and DIVISION fields
So TESTUSER, has YANKEES for team and EAST for Division

I have a Players Table which has TEAM in it, plus other fields
I want TESTUSER when logged in to only see his team: all PLAYERS records with YANKEES for Team

I have a managers table which has DIVISION in it, plus other fields
I want TESTUSER when logged in to only see all PLAYERS records with EAST for Team.

I setup the dynamic user level security tables as described, but don't see how they apply to what I am wanting to do.

This rookie needs some good help :)

mobhar · Post by **mobhar** » Fri Apr 26, 2019 9:26 am

This is interesting.

Could you please post your tables schema including some records in it by using .sql syntax in here for more discussion?
In addition, please explain in more detail, how did you setup Dynamic User Level Security from the project side (for example; I have enabled this and that options from this and that, and bla bla bla), so that we are able to give you some feedback regarding it.