Class PostgresPermissionProvider

Assembly: redb.Postgres.dll

PostgreSQL implementation of permission provider.
Inherits all business logic from PermissionProviderBase.
Only provides PostgreSQL-specific SQL dialect.
IMPORTANT: Uses PostgreSQL function get_user_permissions_for_object()
for efficient recursive permission calculation.
Usage:
services.AddScoped<IPermissionProvider, PostgresPermissionProvider>();

public class PostgresPermissionProvider : PermissionProviderBase, IPermissionProvider

Inheritance

Object→PermissionProviderBase→PostgresPermissionProvider

Implements

Inherited Members

PermissionProviderBase.CanUserDeleteObject(long, long),PermissionProviderBase.CanUserDeleteObject(long, long, CancellationToken),PermissionProviderBase.CanUserDeleteObject(IRedbObject),PermissionProviderBase.CanUserDeleteObject(IRedbObject, IRedbUser),PermissionProviderBase.CanUserDeleteObject(IRedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserDeleteObject(IRedbObject, CancellationToken),PermissionProviderBase.CanUserDeleteObject(RedbObject),PermissionProviderBase.CanUserDeleteObject(RedbObject, IRedbUser),PermissionProviderBase.CanUserDeleteObject(RedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserDeleteObject(RedbObject, CancellationToken),PermissionProviderBase.CanUserEditObject(long, long),PermissionProviderBase.CanUserEditObject(long, long, CancellationToken),PermissionProviderBase.CanUserEditObject(IRedbObject),PermissionProviderBase.CanUserEditObject(IRedbObject, IRedbUser),PermissionProviderBase.CanUserEditObject(IRedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserEditObject(IRedbObject, CancellationToken),PermissionProviderBase.CanUserEditObject(RedbObject),PermissionProviderBase.CanUserEditObject(RedbObject, IRedbUser),PermissionProviderBase.CanUserEditObject(RedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserEditObject(RedbObject, CancellationToken),PermissionProviderBase.CanUserInsertScheme(long, long),PermissionProviderBase.CanUserInsertScheme(long, long, CancellationToken),PermissionProviderBase.CanUserInsertScheme(IRedbScheme),PermissionProviderBase.CanUserInsertScheme(IRedbScheme, IRedbUser),PermissionProviderBase.CanUserInsertScheme(IRedbScheme, IRedbUser, CancellationToken),PermissionProviderBase.CanUserInsertScheme(IRedbScheme, CancellationToken),PermissionProviderBase.CanUserInsertScheme(RedbObject, IRedbUser),PermissionProviderBase.CanUserInsertScheme(RedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserSelectObject(long, long),PermissionProviderBase.CanUserSelectObject(long, long, CancellationToken),PermissionProviderBase.CanUserSelectObject(IRedbObject),PermissionProviderBase.CanUserSelectObject(IRedbObject, IRedbUser),PermissionProviderBase.CanUserSelectObject(IRedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserSelectObject(IRedbObject, CancellationToken),PermissionProviderBase.CanUserSelectObject(RedbObject),PermissionProviderBase.CanUserSelectObject(RedbObject, IRedbUser),PermissionProviderBase.CanUserSelectObject(RedbObject, IRedbUser, CancellationToken),PermissionProviderBase.CanUserSelectObject(RedbObject, CancellationToken),PermissionProviderBase.CanUserSelectObjectSync(long, long),PermissionProviderBase.CreatePermissionAsync(PermissionRequest, IRedbUser?),PermissionProviderBase.CreatePermissionAsync(PermissionRequest, IRedbUser?, CancellationToken),PermissionProviderBase.DeletePermissionAsync(IRedbPermission, IRedbUser?),PermissionProviderBase.DeletePermissionAsync(IRedbPermission, IRedbUser?, CancellationToken),PermissionProviderBase.GetAllEffectivePermissionsAsync(long),PermissionProviderBase.GetAllEffectivePermissionsAsync(long, CancellationToken),PermissionProviderBase.GetAllEffectivePermissionsAsync(IRedbUser),PermissionProviderBase.GetAllEffectivePermissionsAsync(IRedbUser, CancellationToken),PermissionProviderBase.GetCacheStatistics(),PermissionProviderBase.GetEffectivePermissionsAsync(long, long),PermissionProviderBase.GetEffectivePermissionsAsync(long, long, CancellationToken),PermissionProviderBase.GetEffectivePermissionsAsync(IRedbUser, IRedbObject),PermissionProviderBase.GetEffectivePermissionsAsync(IRedbUser, IRedbObject, CancellationToken),PermissionProviderBase.GetEffectivePermissionsBatchAsync(long, long[]),PermissionProviderBase.GetEffectivePermissionsBatchAsync(long, long[], CancellationToken),PermissionProviderBase.GetEffectivePermissionsBatchAsync(IRedbUser, IRedbObject[]),PermissionProviderBase.GetEffectivePermissionsBatchAsync(IRedbUser, IRedbObject[], CancellationToken),PermissionProviderBase.GetEffectivePermissionViaSql(long, long),PermissionProviderBase.GetEffectivePermissionViaSqlAsync(long, long),PermissionProviderBase.GetEffectivePermissionViaSqlAsync(long, long, CancellationToken),PermissionProviderBase.GetPermissionByIdAsync(long),PermissionProviderBase.GetPermissionByIdAsync(long, CancellationToken),PermissionProviderBase.GetPermissionCountAsync(),PermissionProviderBase.GetPermissionCountAsync(CancellationToken),PermissionProviderBase.GetPermissionsByObjectAsync(IRedbObject),PermissionProviderBase.GetPermissionsByObjectAsync(IRedbObject, CancellationToken),PermissionProviderBase.GetPermissionsByRoleAsync(IRedbRole),PermissionProviderBase.GetPermissionsByRoleAsync(IRedbRole, CancellationToken),PermissionProviderBase.GetPermissionsByUserAsync(IRedbUser),PermissionProviderBase.GetPermissionsByUserAsync(IRedbUser, CancellationToken),PermissionProviderBase.GetReadableObjectIds(),PermissionProviderBase.GetReadableObjectIds(long),PermissionProviderBase.GetReadableObjectIds(IRedbUser),PermissionProviderBase.GetReadableObjectIdsAsync(long),PermissionProviderBase.GetReadableObjectIdsAsync(long, CancellationToken),PermissionProviderBase.GetRolePermissionCountAsync(IRedbRole),PermissionProviderBase.GetRolePermissionCountAsync(IRedbRole, CancellationToken),PermissionProviderBase.GetSelectableObjectIdsAsync(IReadOnlyCollection<long>, long, CancellationToken),PermissionProviderBase.GetUserPermissionCountAsync(long),PermissionProviderBase.GetUserPermissionCountAsync(long, CancellationToken),PermissionProviderBase.GetUserPermissionCountAsync(IRedbUser),PermissionProviderBase.GetUserPermissionCountAsync(IRedbUser, CancellationToken),PermissionProviderBase.GrantPermissionAsync(IRedbRole, IRedbObject, PermissionAction, IRedbUser?),PermissionProviderBase.GrantPermissionAsync(IRedbRole, IRedbObject, PermissionAction, IRedbUser?, CancellationToken),PermissionProviderBase.GrantPermissionAsync(IRedbUser, IRedbObject, PermissionAction, IRedbUser?),PermissionProviderBase.GrantPermissionAsync(IRedbUser, IRedbObject, PermissionAction, IRedbUser?, CancellationToken),PermissionProviderBase.GrantPermissionInternalAsync(long?, long?, long, PermissionAction, IRedbUser?),PermissionProviderBase.GrantPermissionInternalAsync(long?, long?, long, PermissionAction, IRedbUser?, CancellationToken),PermissionProviderBase.InvalidatePermissionCache(long?, long?),PermissionProviderBase.OnPermissionCreatedAsync(IRedbPermission, IRedbUser?),PermissionProviderBase.OnPermissionCreatedAsync(IRedbPermission, IRedbUser?, CancellationToken),PermissionProviderBase.OnPermissionDeletedAsync(IRedbPermission, IRedbUser?),PermissionProviderBase.OnPermissionDeletedAsync(IRedbPermission, IRedbUser?, CancellationToken),PermissionProviderBase.OnPermissionUpdatedAsync(IRedbPermission, IRedbUser?),PermissionProviderBase.OnPermissionUpdatedAsync(IRedbPermission, IRedbUser?, CancellationToken),PermissionProviderBase.RevokeAllRolePermissionsAsync(IRedbRole, IRedbUser?),PermissionProviderBase.RevokeAllRolePermissionsAsync(IRedbRole, IRedbUser?, CancellationToken),PermissionProviderBase.RevokeAllUserPermissionsAsync(IRedbUser, IRedbUser?),PermissionProviderBase.RevokeAllUserPermissionsAsync(IRedbUser, IRedbUser?, CancellationToken),PermissionProviderBase.RevokePermissionAsync(IRedbRole, IRedbObject, IRedbUser?),PermissionProviderBase.RevokePermissionAsync(IRedbRole, IRedbObject, IRedbUser?, CancellationToken),PermissionProviderBase.RevokePermissionAsync(IRedbUser, IRedbObject, IRedbUser?),PermissionProviderBase.RevokePermissionAsync(IRedbUser, IRedbObject, IRedbUser?, CancellationToken),PermissionProviderBase.RevokePermissionInternalAsync(long?, long?, long, IRedbUser?),PermissionProviderBase.RevokePermissionInternalAsync(long?, long?, long, IRedbUser?, CancellationToken),PermissionProviderBase.UpdatePermissionAsync(IRedbPermission, PermissionRequest, IRedbUser?),PermissionProviderBase.UpdatePermissionAsync(IRedbPermission, PermissionRequest, IRedbUser?, CancellationToken)

Constructors