Set Up Table Sharing
Security:
Set Up: Assignable Roles
domain in the Organization and Roles functional area.To enable sharing a table with another user or security group, you create tenant-specific roles that correspond to the table-related Workday provided roles. Sharing tables is a way to control access to individual tables.
- Access theMaintain Assignable Rolestask.
- Set up roles for the table-related Workday-provided roles.When you set up these tenant-specific roles, consider:
- The name you enter inRole Namebecomes the prompt value in thePermissioncolumn on theEdit Table Sharingtask.
- The security groups you select inRole Assignees Restricted todetermine which users and groups you can share a table with. Select user-based security groups for the Prism roles.
- The security groups you select inAssigned/Reviewed by Security Groupsdetermine which users can share a table.
Add the roles in the table below, but substitute security groups that your organization needs instead of Prism Data Writer and Prism Data Administrator:Role NameWorkday RoleEnabled forSelf-AssignRole Assignees Restricted toAssigned/Reviewed by Security GroupsTable Owner - Prism01. Table Owner - PrismPrism TablesYesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorTable Editor - Prism02. Table Editor - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorTable Schema Editor - Prism03. Table Schema Editor - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorTable Viewer - Prism04. Table Viewer - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorTable Schema Viewer - Prism05. Table Schema Viewer - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorCan Truncate Table Data - Prism06. Can Truncate Table Data - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorCan Delete Table Data - Prism07. Can Delete Table Data - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorCan Update Table Data - Prism08. Can Update Table Data - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorCan Insert Table Data - Prism09. Can Insert Table Data - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorCan Select Table Data - Prism10. Can Select Table Data - PrismPrism TablesPrism Data WriterPrism Data AdministratorPrism Table Owner (Workday Owned)Security AdministratorYou can substitute any user-based security groups your organization has created for Prism-related tasks instead of selecting Prism Data Writer or Prism Data Administrator.