Tables (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.]

The Repository.Item schema contains the following tables.

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

Reference

Repository.Item Schema

Send comments about this topic to Microsoft.