SA-3493

Summary

New user created is not able to login to CMD.

Error Messages

No Data views has been defined for this user

Steps to Reproduce

Try to login as newly created user

Root Cause

Application role is not granted for the user at database level for database account of user “clared”

Also, C” is capital in the User ID created in security module for user “clared”. However, the user name is configured with small “c” in Vantage.init file.

Resolution

Executed below SQLs as “sys” user to grant application role to database user of “clared”:

grant VANTAGE_APP_ROLE to <database account of clared >;
alter user < database account of clared > default role all except VANTAGE_APP_ROLE;

Note: Please replace <database account of clared > with database account of the user “clared”.

Modified “Clared” instead of “clared" in Vantage.init file, request user to login as “Clared” (with capital “C”)