SQL Editor

[Former Member]

When I try to launch the SQL Editor, the following

exception is thrown. Warning 2011: You are not

authorized to use this functionality.

The user has been assigned to the VCRole.

Thanks.

[Former Member · Accepted solution]

If you are using the JDBC connector to access data from relational sys-tems, the SQL Editor offers the liberty to create any SQL statement and execute it against the JDBC source. Before the SQL-Editor can be used, it has to be turned on. You have to know that certain security risks are intrinsic for this feature and as default setting this functionality is turned off. The same is true for the MDX Editor. To turn this functionality on, the administrator has to set the property vc.bi.sqlEditorEnabled in the Visual Administrator (the administration UI for the J2EE Server) to true. Once this has been done, the SQL Editor and SQL field in the input port become visible.

[Former Member · Accepted solution]

What path in the admin tool would this be found?

[Former Member · Accepted solution]

Under the Cluster tab Visual Composer Server...

Scott

[moyalynne · Accepted solution]

here's the documentation in the VC Installation & Configuration guide for this:

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/43/f9facc992e6bece10000000a11466f/frameset.htm">http://help.sap.com/saphelp_nw2004s

/helpdata/en/43/f9facc992e6bece10000000a11466f/frameset.htm</a>

be sure to read about the security risks in the VC Security Guide before you enable the SQL Editor:

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/44/366d3c78da48a1e10000000a114a6b/frameset.htm">http://help.sap.com/saphelp_nw2004s

/helpdata/en/44/366d3c78da48a1e10000000a114a6b/frameset.htm</a>

thanks,

-m

[Former Member]

Thanks for the quick response. Everything

is accessible now.