Share a Table with Others
Any of these security requirements:
- Prism: Tables Owner Managedomain in the Prism Analytics functional area.
- Table Ownerpermission on the table.
When you create a table, you're the table owner. Being the owner of a table means you have
Table Owner
permission on the table. As a table owner,
you can share it with other users and security groups. The table sharing feature is
a way to control access to individual tables.You might want to share a table with someone else so they can edit it, or import it
into a derived dataset.
Table permissions control either:
- Metadata. Example: Table Schema Editor, Table Schema Viewer.
- Data. Example: Can Delete Table Data, Can Truncate Table Data, Can Select Table Data, Can Insert Table Data.
- Metadata and Data. Example: Table Owner, Table Editor, Table Viewer.
- Access theView Table Detailsreport.
- Select .
- Assign a user or security group to the desiredPermission.When you grant someone one of the data permissions, that user must have access to view the table schema. Example: If you want to grant Can Insert Table Data permission, you must also grant either Table Schema Viewer or Table Viewer permission.
- (Optional) Share the table with more users, or remove access from users listed in the table.
- When you're done sharing the table with others, clickOK.