An example would be to have two client pc's. PC 1 would be the Administrator and also the DBA on the database, PC 2 would be the non-administrator developer pc. PC 1 would have Quest Central for Databases v.4.0.1 installed with Tuning 5.0 plug-ins, PC 2 would have the SQL Navigator Xpert Option 4.4 installed. After the role is granted to the non-dba user and tries to connect from PC 1, a message box would display 'This user account must be granted the proper roles...'.
1. The user needs to be on the latest version of SQL Navigator Xpert Edition, v. 4.4 is available via <http://www.quest.com/requests/?RequestDefID=1931>.
2. Run the attached SQLabOption.exe on the developer's client pc
3. Open SQLNAV/XPERT
4. Connect to SQLNAV/XPERT as the <dba user> and GRANT the QUEST_SL role to the nondba. You may want to revoke it first then re-grant the role.
5. Connect as <nondba>.
Further Explanation of the issue:
PC 1 had Quest Central for Oracle v. 2.7 installed which included Tuning plug-ins v. 4.7.3 PC 2 had SQL Navigator Xpert Option v. 4.7.2 installed. Since both plug-ins were compatible, the non-dba users coming from PC 2, had no issues connecting from the SQL Navigator Xpert Option. If PC 1 were to upgrade to QC 4.0.1 and go through the 'SQLAB User Management' screen to grant the role, PC 2 would receive the error.
The versions from QC 2.7 AND 4.0 are packaged with SQLAB 4.7.3. For SQL Navigator and TOAD, the version for the SQLAB Option is 4.7.2. SQLAB 4.7.3 is the workable/compaitible version with Tuning 5.0.
