After MSSQL database restore, the schema used still seems to be dbo, how to fix this?
Release : All Supported Clarity with MSSQL
Run the commands as follows (do not change the database name):
sp_change_users_login 'AUTO_FIX', 'niku'
sp_change_users_login 'AUTO_FIX', 'ppm_dwh'
OR
Make sure in SQL Management Console that default schema name for the niku user id is niku and ppm_dwh user id is ppm_dwh