Community and Support
            Knowledge Base Analytics Plus Manage Settings User Management

            Providing Admin Role

            1. Login to pgsql database using command prompt 

            2. 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=# 


            3. Selecting accountsdb

            4. 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=#


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

            Updated: 18 Aug 2017 06:16 AM
            Helpful?  
            Help us to make this article better
            0 0