Providing Admin Role
Login to pgsql database using command prompt
D:\>cd MEReports\AnalyticsPlus\pgsql\bin>
D:\MEReports\AnalyticsPlus\pgsql\bin>psql.exe -h localhost -p 33366 -U postgres
psql (9.5.1)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.
postgres=#
Selecting accountsdb
postgres=# \c accountsdb
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
You are now connected to database "accountsdb" as user "postgres".
accountsdb=#
Execute the query
Get the user's Zuid (replace first_name with appropriate value)
select zuid,first_name from iamuser;
Make him Admin by replacing the text in red with the value
update iamuser set user_role=2 where zuid in ('zuid')
New to ADSelfService Plus?
Related Articles
Changing hostname in Servicedesk >Admin >Advanced Analytics settings
Lets assume analyticsplus.server.com:8443 as the FQDN that you wish to update in servicedesk>Admin>Advanced analytics settings page Launch Command prompt in servicedesk server as administrator Navigate to <ServicedeskPlus_home>\pgsql\bin >psql.exe -U ...Unable to integrate ServiceDesk Plus with Analytics Plus after applying SSL
Note: This problem occurs only with self signed certificates in Analytics Plus. Issue: [10:23:16:526]|[09-05-2016]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...Unable to integrate SDP MSP with Analytics Plus after applying SSL
Note: This problem occurs only with self signed certificates in Analytics Plus. Issue: [10:23:16:526]|[09-05-2020]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...Password Reset for Server Administrator
This instruction applies to Server Administrators using the On-Premises version of Analytics Plus who have forgotten their password and are unable to reset their password using the "forgot password" option. Please fill the form below to receive ...How to activate the personal edition of Analytics Plus
I have installed Analytics Plus and I don't see an option to activate Personal Edition. How do I get a personal Edition of Analytics Plus? Analytics Plus now has a download setup where you will be on the Professional Edition for the first 30 days. ...