How to Implement PowerCenter on Microsoft Azure

Back Next

Step 3. Assign Privileges to the Database Users from the Command Line

Relational database users need to create a domain configuration repository and a PowerCenter repository with certain privileges in the command line.

To create users and to assign privileges, enter the following syntax in the command line:

ALTER ROLE db_datareader ADD MEMBER "<username>"; 
ALTER ROLE db_datawriter ADD MEMBER "<username>";
ALTER ROLE db_ddladmin ADD MEMBER "<username>"

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.