Foreign Keys for Entity SecurityGroupPermisison

[Nicole Bubear]

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.

[Adrian Crum-3]

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.
>

[Nicole Bubear]

Thanks for the info and pointing out the entity reference screen. This is
really helpful as I'm fairly new to OFBiz and didn't know those tools
existed.


On 10 October 2013 11:20, Adrian Crum <[hidden email]>wrote:

> 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.
>>
>>