AddPrincipal Procedure (Repository 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.]

Creates a Modeling Services database login and user, assigning the new user to the specified Modeling Services role.

[Repository].[AddPrincipal] ( @principal, @role )

Arguments

@principal

Type: sysname. The Windows principal name to be given access to the Modeling Services database. There cannot be a login already associated with this Principal.

@role

Type: sysname. The Modeling Services role for the new principal. Permitted roles include RepositoryUser, RepositoryReader, RepositoryReaderWriter, RepositoryAdministrator.

Remarks

See Also

Reference

Repository Procedures
Repository Schema

Send comments about this topic to Microsoft.