Overview
Publishers shall be able to add or remove permissions to other users related to the publisher. These "Sub-Publishers" should have the same access as publishers except for creating other users and limiting permissions.
In order to do this, several tasks must be completed.
- Sub-Publisher role must be added
- Manage Users Page
- Publishers need to be able to select the Sub-Publisher role
- When Publishers create a Sub-Publisher, the Publisher needs to be able to select the publications the new user has access to
- When Publishers create new Publications the Publisher needs to be able to select the users (that are for that have access to the new Publication
- Database
- New Table - UserPublication
- Columns: UserID, PublicationID
- UserID should be a foreign key to the User's UserID column
- PublicationID should be a foreign key to the Publication's PublicationID column
- New Table - UserPublication
- Server-Side code
- When displaying Publications to Sub-Publishers, they need to be restricted to Publications that can be found through the user's mapping.
- New Management Page for Publishers
- A new page will need to be added (or a section in a page) that will allow Publishers to manage permissions for Sub-Publishers.