Hi Manoj
There is no straight forward approach, Kindly use the below sql query as a workaround to find the user with which the application was installed, So this gives you the specific user from where the application has been created and installed, user name can be found at column user_name.
To find the user who created the application object
select * from [dbo].[cfg_hdb_object] where oper_type='3' AND object_type='CfgServer' AND application= 'default'To find the user with which the application was installed in the server
select * from [dbo].[cfg_hdb_object] where oper_type='4' AND application='ITCUtility'To Answer your other question, if changing the default password will impact the applications installed with, Yes it will impact very few applications like GWS, GIR (application.yaml) etc., if they are configured with the default user to connect with the config server, Mostly service accounts will be used for these type of applications to avoid the security concern. However please make sure any such applications are not using the default account in their configuration.
------------------------------
Karthik Eswaran
------------------------------
Original Message:
Sent: 03-08-2019 06:34
From: Manoj Mohan
Subject: Need to know applications
Hi,
How to know list of applications which are installed using default user.And If we changes the password of default user will it impact applications installed using default user.
#Implementation
------------------------------
Manoj Mohan
------------------------------