If you check the entity reference screen in Web Tools, you will see this
explanation:
"Defines a permission available to a security group; there is no FK to
SecurityPermission because we want to leave open the possibility of
ad-hoc permissions, especially for the Entity Data Maintenance pages
which have TONS of permissions"
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 10/10/2013 8:36 AM, Nicole Bubear wrote:
Hi,
Is there a reason the SecurityGroupPermission entity doesn't have a foreign
key relationship with the SecurityPermission field permissionId?
I've been working on a project that exposes security group
creation/modification on a per client basis so that they are able to grant
permissions to their users based off the permissions they themselves have.
In our system I discovered that there were permission ids associated with
security groups but there was no entry for those permission ids in the
security_permissions table. I'm not sure how they got there in the first
place but assumed they were permissions that previously existed and then
were removed form the security permissions table.
Thanks.
