Export (0) Print
Expand All

Repository.Item Schema

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

Provides support for features that apply to items in the Modeling Services database. This includes security, Folder management, and change tracking.

Type Description

FolderId

An integer that uniquely identifies a Modeling Services Folder within a single instance of the Modeling Services database.

FolderName

A unicode string for a Modeling Services Folder name, having a maximum length of 100 characters.

Principal

A binary security identifier (SID) of a principal.

RemovalPolicyName

A name of a removal policy used with lifetime services.

SecuredOperationId

A GUID that represents an operation, such as read or update, in the Modeling Services database.

SecuredResource

A value of a secured resource.

SecuredResourceId

An integer that uniquely identifies a secured resource in the Modeling Services database.

SecuredResourceKindId

A GUID that represents the kind of a secured resource.

SecuredResourcePermissionId

An integer that uniquely identifies a permission for a given resource.

SecurityClaim

A value of a security claim.

SecurityClaimId

An integer that uniquely identifies a security claim.

SecurityClaimKindId

A GUID that represents the kind of security claim.

Session

An integer identifier for a database session (a SQL Server SPID).

Sid

A Windows security identifier (SID).

View Description

CurrentPermissions

Returns a list of permissions for the current database session. This list includes resources and the operations that are allowed on those resources.

Folders

Stores Modeling Services Folders that help to organize, secure, and manage items in tables that use the Folder design pattern.

PermissionRules

Horn clause based inference rules for permissions (for example, if a principal is authorized to perform a read operation on the .NET Framework resource Folder, then the principal is authorized to perform the read operation on the .NET Framework\2.0 resource Folder).

ReadableFoldersView

Provides a list of Folder identifiers that the caller has permissions to read.

RemovalPolicies

Stores removal policies used by Modeling Services lifetime services.

SecuredOperations

Stores a list of securable operations in the Modeling Services database. Two operations are predefined: reading and updating.

SecuredResourceKinds

Provides a list of the kinds of resources that can be secured in the Modeling Services database. A Folder is an example of a kind of secured resource.

SecuredResourcePermissions

Stores a list of permitted operations on resources for a given claim.

SecuredResources

Stores a list of secured resources and their kinds.

SecurityClaimKinds

Provides a list of the kind of claims in the Modeling Services database. An example of a claim is a Windows security identifier (SID).

SecurityClaims

Stores claims and their claim kind.

SessionsPermissions

Returns a list of permitted resource operations for the current database session.

SessionsSecurityClaims

Lists the active database sessions and their associated claim identifiers.

TheSessionsSecurityClaims

Lists the current database session and its associated claim identifiers.

UpdatableFoldersView

Provides a list of Folder identifiers that the caller has permissions to update.

Procedure Description

AddAuditing

Adds auditing support to a target view that follows Modeling Services design patterns. To use this procedure, the Modeling Services database must have been created with auditing enabled.

AddChangeTracking

Enables change tracking on the target view.

AddFolderForeignKey

Adds a foreign key constraint to the [Repository.Item].[FoldersTable] table.

AddStandardPatterns

Adds standard Modeling Services design patterns to a target view and underlying table. This procedure combines calls to several stored procedures related to Modeling Services patterns. These procedures include [Repository].[CreateIdSequence], [Repository.Item].[AddFolderForeignKey], and [Repository.Item].[AddViewsInsteadOfTriggers]. Depending on the installed settings, it also calls the procedures [Repository.Item].[AddAuditing] and [Repository.Item].[AddChangeTracking].

AddViewsInsteadOfTriggers

Adds INSTEAD OF triggers to a target view that make the view updatable. In addition to supporting insert, update, and delete statements, the triggers also provide Folder based security when using the default filters.

BuildChangeScript

Builds a change script from an XML document that describes the changes.

CreateFoldersPath

Creates one or more Modeling Services Folders based on a Folder path.

GrantClaimPermission

Grants a claim permission to perform an operation on a resource.

GrantPrincipalFolderAccess

Grants a principal permission to perform an operation on a Folder resource.

GrantPrincipalPermission

Grants a principal permission to perform an operation on a resource.

RaiseErrorPermissions

Raises a security permissions error.

RemoveOldItems

Removes items from the Modeling Services database that are associated with a specific lifetime policy. This is an internal procedure that is part of lifetime services. It is not meant to be called directly.

RevokeClaimPermission

Revokes a claim permission.

RevokePrincipalFolderAccess

Revokes a claim permission on a specific Folder.

RevokePrincipalPermission

Revokes a claim permission on a resource.

SetLogonSessionsSecurityClaims

Establishes the security claims for a new database session. This is an infrastructure procedure. Do not call this procedure directly.

UncheckedGrantClaimPermission

Grants claim permissions without the normal security checks. This is an infrastructure procedure that should only be called by Modeling Services. Do not call this procedure directly.

Function Description

FoldersPath

Returns a textual representation of a Folder path. The path uses a forward-slash as a delimiter.

Internal SessionMayPerformOperation

This is an internal function used by Modeling Services. Do not access this function directly.

NormalizeFoldersPath

This is an internal function used by Modeling Services. Do not access this function directly.

OperatableResources

Returns all the resources of a specific kind that the current session may perform a specific operation on.

PathsFolder

Returns the Folder identifier that is associated with the given Folder path.

PrincipalsId

Returns the Windows security identifier (SID) for the principal.

ReadableFolders

Returns a list of Folders that the caller has permissions to read.

ReadableResources

Returns a list of resources that the caller has permissions to read.

SessionMayGrantOrRevokePermission

Returns a bit flag that specifies whether the caller can grant or revoke a permission for a given resource and operation.

SessionMayPerformOperation

Returns a bit flag that specifies whether the caller can perform an operation on a given resource.

SessionMayReadFolder

Returns a bit flag that specifies whether the caller has permission to read data that is owned by a Folder.

SessionMayReadResource

Returns a bit flag that specifies whether the caller has permission to read a given resource.

SessionMayUpdateFolder

Returns a bit flag that specifies whether the caller has permission to update a Folder.

SessionMayUpdateResource

Returns a bit flag that specifies whether the caller has permission to update a resource.

Subfolders

Returns a table that lists the subfolders of the given Folder.

SubfoldersAndFolder

Returns a table that lists the subfolders of the given Folder. This function includes the target Folder in the results.

UpdatableFolders

Returns a list of Folders that the caller has permission to update.

UpdatableResources

Returns a list of resources that the caller has permission to update.

Table Description

FoldersTable

Stores Modeling Services Folders that help to organize, secure, and manage items in tables that use the Folder design pattern.

Internal FolderPermissionRules

This is an infrastructure table. Do not use directly.

PermissionRulesTable

Horn clause based inference rules for permissions (for example, if a principal is authorized to perform a read operation on the .NET Framework resource Folder, then the principal is authorized to perform the read operation on the .NET Framework\2.0 resource Folder).

RemovalPoliciesTable

Stores removal policies used by Modeling Services lifetime services.

SecuredOperationsTable

Stores a list of securable operations in the Modeling Services database. Two operations are predefined: reading and updating.

SecuredResourceKindsTable

Provides a list of the kinds of resources that can be secured in the Modeling Services database. A Folder is an example of a kind of secured resource.

SecuredResourcePermissionsTable

Stores a list of permitted operations on resources for a given claim.

SecuredResourcesTable

Stores a list of secured resources and their kinds.

SecurityClaimKindsTable

Provides a list of the kind of claims in the Modeling Services database. An example of a claim is a Windows security identifier (SID).

SecurityClaimsTable

Stores claims and their claim kind.

SessionsSecurityClaimsTable

Lists the active database sessions and their associated claim identifiers.

Send comments about this topic to Microsoft.

Show:
© 2014 Microsoft