I was setting up some BDC models in SharePoint 2010 which involves managing authorization levels for BDC Metadata Store.
In Central Admin – BDC Service – Set Metadata Store Permissions
Add an user and the Permissions box will be populated with different authorization roles. Initially I couldn’t find any documentation on these roles.
So, after some digging around, here it is:
Edit – Create, delete, and Update metadata for BCS
Execute – Permission to make a call to an external system
Selectable in Clients – If you need to provide users with access to utilities like entity picker
Set Permissions – Gives the current user the ability to grant rights to other users.