Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
[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.