PermissionID Description

[Mackiez]

Good morning,

I have queried the EA DB to put together a list of users, the user permissions, the groups those users belong to and the permissions the groups have. The issue I find is specific to Permissions.

I can find which Permission ID a user or group is linked to, but I cannot find a description for the Permission IDs. The table "t_secpermission" is empty, which is where I was expecting to find these descriptions.

Thanks for your help.

[qwerty]

t_secpermission is not used for anything (as it seems). The following tables are used:

t_secgroup: Security groups
t_secgrouppermission: Security group permissions
t_seclocks: Security locks
t_secpolicies: Security settings
t_secuser: Security users
t_secusergroup: Security user/group assignments
t_secuserpermission: Security user permissions

t_secgrouppermission:

Currently there are 38 different permission defines (0..37). Each number represents one permis- sion in the group permission settings. A few are detailed below. If you need to know specific numbers just define a test group, assign a single permission and see what number it creates.

(cite from my Inside book)

q.

[Mackiez]

Thanks for the input QWERTY.

Do you know where I can find the descriptions for those 38 different permissions you mentioned?

Thanks,

[qwerty]

Read the quote above That's all you would find anywhere.

q.

[Mackiez]

I feel like Homer Simpson... "Dope!"

[Guillaume]

I recently shared the description via the article below:

https://goo.gl/zvN8Nu

QWERTY, I'm happy for you to include this list in the next update of your Inside EA ebook

cheers

[qwerty]

Thanks, Guillaume, I'll do so 

q.

[Eve]

I looked briefly at the list already shared.

If you're only interested in name-description mapping I'd recommendhttp://sparxsystems.com/enterprise_architect_user_guide/13.0/team_support/permissionlist.html.

I haven't looked at the other list much, but I noticed that the descriptions of the first two items are swapped.

[Guillaume]

Hi,

I added the permissions introduced in EA13 to the list, see https://goo.gl/zvN8Nu
-> Edit Scripts, Run Scripts, Configure Project Prerequisites

Note that the last permission is missing from dhttp://sparxsystems.com/enterprise_architect_user_guide/13.0/team_support/permissionlist.html

QWERTY, please feel free updating it in Inside EA book

[qwerty]

Thanks, Guillaume. I have uploaded an update containing the new key.

Cheers,

q.