Dong Shin 06.03.2011

PPM Role Permissions
- Project – Create, Copy, Modify, Enter Monthly Status, Financial Status
- Funding Request – Create, Modify
- Manage Contracts
- Manage Appropriations
- Monthly Status Report
- User Management – Create New User, User Management, Activate New Users
- Utils – Local Logs, Server Logs, Query Logs, Database Management
Create roles table
- DROP TABLE `user_roles`
- DROP TABLE `roles`
- CREATE TABLE `project_portfolio`.`roles` ( `type` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `create_project` TINYINT NULL DEFAULT NULL , `copy_project` TINYINT NULL DEFAULT NULL , `modify_project` TINYINT NULL DEFAULT NULL , `enter_monthly_status_data` TINYINT NULL DEFAULT NULL , `financial_status_data` TINYINT NULL DEFAULT NULL , `create_funding_request` TINYINT NULL DEFAULT NULL , `modify_funding_request` TINYINT NULL DEFAULT NULL , `manage_contracts` TINYINT NULL DEFAULT NULL , `manage_appropriations` TINYINT NULL DEFAULT NULL , `monthly_status_report` TINYINT NULL DEFAULT NULL , `create_new_user` TINYINT NULL DEFAULT NULL , `user_management` TINYINT NULL DEFAULT NULL , `activate_new_users` TINYINT NULL DEFAULT NULL , `local_logs` TINYINT NULL DEFAULT NULL , `server_logs` TINYINT NULL DEFAULT NULL , `query_logs` TINYINT NULL DEFAULT NULL , `database_management` TINYINT NULL DEFAULT NULL , PRIMARY KEY ( `type` )) ENGINE = InnoDB ;
working on Roles Management
- flipped the data around to view data more friendly(?)

viztales