@Ganpat Patel Logic app service now connector only supports the username and password credentials as documented here.
The service now team can confirm what would be equivalent role that needs to be provided to user as we see the user/password under the managed instance password blade a service now end.
Logic app connector internal calls the REST/SOAP API of service endpoint.