To hide the Edit in Datasheet, Export to Spreadsheet and Open with Access menu items. Create a custom Permission Level using the directions found here.
When specifying the permissions for the custom Permission Level make sure Use Client Integration Features is unchecked, this will prevent users from launching client applications which includes Access embedded in the datasheet, as well as the external applications. Unchecking Use Remote Interfaces is probably a safe bet as well.
Frustrated by the limit of existing Permission Levels within SharePoint (Full Control, Design, Approve, Contribute, Read, etc.) I finally discovered how to create my own. These are created at the Site level like this:
- Site Actions > Site Settings > Advanced Permissions
- Settings > Permission Levels
- Add a Permission Level
- Enter a Name and a Description
- Select permissions from the beautiful buffet of security settings are available
- Click Create
At this point the new Permission Level is available when assigning permissions to a user or group!
Displaying teams in Data Manager is simply based on the current user’s Team access. Change their Team membership using BPC Administration.