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.