Skip to content

Table Permission#

Bases: SsasEditableRecord

TBD.

SSAS spec: Microsoft

Source code in pbi_core/ssas/model_tables/table_permission/table_permission.py 
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
@define()
class TablePermission(SsasEditableRecord):
    """TBD.

    SSAS spec: [Microsoft](https://learn.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas-t/ac2ceeb3-a54e-4bf5-85b0-a770d4b1716e)
    """

    error_message: Final[str | None] = field(default=None, eq=False, on_setattr=setters.frozen)
    filter_expression: str | None = field(default=None, eq=True)
    metadata_permission: MetadataPermission = field(eq=True)
    role_id: int = field(eq=True)
    state: Final[DataState] = field(eq=False, on_setattr=setters.frozen, default=DataState.READY)
    table_id: int = field(eq=True)

    modified_time: Final[datetime.datetime] = field(eq=False, on_setattr=setters.frozen, repr=False)

    _commands: BaseCommands = field(default=SsasCommands.table_permission, init=False, repr=False, eq=False)

    def pbi_core_name(self) -> str:
        return self.table().pbi_core_name()

    def __repr__(self) -> str:
        role_name = self.role().pbi_core_name()
        table_name = self.table().pbi_core_name()
        return f"TablePermission(id: {self.id}, role: {role_name}, table: {table_name})"

    def role(self) -> "Role":
        return self._tabular_model.roles.find(self.role_id)

    def table(self) -> "Table":
        return self._tabular_model.tables.find(self.table_id)

    def column_permissions(self) -> set["ColumnPermission"]:
        return self._tabular_model.column_permissions.find_all({"table_permission_id": self.id})

    def children_base(self) -> frozenset["LinkedEntity"]:
        return LinkedEntity.from_iter(self.column_permissions(), by="column_permission") | LinkedEntity.from_iter(
            self.annotations(),
            by="annotation",
        )

    def parents_base(self) -> frozenset["LinkedEntity"]:
        return LinkedEntity.from_iter(
            {self.role()},
            by="role",
        ) | LinkedEntity.from_iter(
            {self.table()},
            by="table",
        )