AddAuditing Procedure (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.]
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.
[Repository.Item].[AddAuditing] ( @schema, @baseName, @readerRole, @securityFilter, @folderColumn )
Arguments
@schema
Type: sysname. The schema of the target view.
@baseName
Type: nvarchar(123). The name of the target view. The underlying table must use the same base name appended with the word "Table". The combined length of the schema and table name cannot be greater than 96 characters.
@readerRole
Type: sysname. An optional role name permitted to use the generated auditing function. (Default = N'RepositoryChangeDataCaptureReader')
@securityFilter
Type: smallint. The type of security filter to apply to the generated auditing function. Possible values include 0 for no security filter, 1 for administrator security filter, or 2 for Folder security filter. (Default = 2)
@folderColumn
Type: sysname. The name of the Folder column in the target view. (Default = N'Folder')