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')