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.

Data Types (UDTs)

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).

Views

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.

Procedures

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.

Functions

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.

Tables

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.

Remarks

See Also

Other Resources

"Oslo" Repository Overview
"Oslo" Repository Architecture

Send comments about this topic to Microsoft.