admin link available to a standard user

Products

• VMware Smart Assurance

Issue/Introduction

After upgrading, the admin menu is now visible to non-admin users.

Environment

Watch4Net 7.7.0.3

Resolution

• Connect to the APG database

apg/bin/mysql-client.sh

Enter username: [apg] 

Enter database: [apg]

Enter password: watch4net unless it has been updated.

• Run the following querry

mysql> select * from master.module_identifiers ;
+--------+----------------------------------------------------+----------------+
| name   | url                                                | default_access |
+--------+----------------------------------------------------+----------------+
| Smarts | /dojoviews/view.html?viewname=ConfigurationManager |              1 |
+--------+----------------------------------------------------+----------------+

• If the default_access value is 1, change it to 0

mysql> update master.module_identifiers set default_access = '0' where name = 'Smarts';

• Verify that the default_access value

mysql> select * from master.module_identifiers ;
+--------+----------------------------------------------------+----------------+
| name   | url                                                | default_access |
+--------+----------------------------------------------------+----------------+
| Smarts | /dojoviews/view.html?viewname=ConfigurationManager |              0 |
+--------+----------------------------------------------------+----------------+
1 row in set (0.00 sec)

• Verify that the admin menu is not present.