If you have a empower version lower than 8.6

By following the steps below, you can add a user as Admin User based on his PrincipalId.

(If there is no CD Admin already or anymore)

1. Open the table: tbl_Users 

Right click on tbl-Users and select Select Top 1000 Rows.

2. Find the desired user with the following SQL statement

SELECT TOP (1000) [PrincipalID]
,[FirstName]
,[LastName]
,[LastModified]
,[LastLogin]
,[IsDisabled]
,[IsSynced]
,[LoginName]
,[DeletedOn]
FROM [dbo].[tbl_Users]
Where LastName = 'UserName' --> Name of the desired user

3. Copy the PrincipalId of the user

4. Execute the following function in the SQL Management Studio:

Programmability-->

StoredProcedures-->

spAddAdminUserPrincipal 

Right-click on dbo.spAddAdminUserPrincipal and execute theStored Procedure

5. Insert the PrincipalId of the user 

Attention: The PincipalId must be set in quotation marks

In the field Value for the parameter @IsCDAdmin insert the value 1, thus the user gets the cdAdmin rights.

Click OK: Now the user should have CDAdmin rights.

Do you still have questions? 

If you have further questions, please do not hesitate to contact us.

empower version 8.6 or higher

By following the steps below, you can add a user as Admin User based on his PrincipalId.

(If there is no CD Admin already or anymore)

1.  Open the table: core.PrincipalUsers
   Right-click on core.PrincipalUsers and select Select Top 1000 Rows.
   
   
2. Find the wanted user with the following SQL statement. For example:

   SELECT TOP (1000) [PrincipalId]
   ,[FirstName]
   ,[LastName]
   ,[LoginName]
   ,[IsSynced]
   ,[IsDisabled]
   ,[LastLoginOn]
   ,[LastModifiedOn]
   ,[DeletedOn]
   FROM [core].[PrincipalUsers]
   WHERE LastName = 'UserName' --> the name of the user

3. Copy the PrincipalId of the user
   
   
   
   
4. Navigate to
   

   Programmability-->

   StoredProcedures-->

   core.spAddAdminUserPrincipal 

   
   
   
   

5. Insert the PrincipalId of the user 

   Important: The PrincipalId must be set in quotation marks

   
   

   Insert the value 1 in the Value field for the @IsCDAdmin parameter, so the user gets the cdAdmin rights.

   Click the OK button: Now the user should have CD Admin rights.

   Still have any questions? 

   If you have any further questions, please do not hesitate to contact us.

   Support kontaktieren