teiid-designer-issues
January 2014
teiid-designer-issues@lists.jboss.org
- 1 participants
- 245 discussions
[JBoss JIRA] (TEIIDDES-2017) NPE while using Teiid Connection Importer
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2017:
--------------------------------------
Summary: NPE while using Teiid Connection Importer
Key: TEIIDDES-2017
URL: https://issues.jboss.org/browse/TEIIDDES-2017
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 8.3
Reporter: Ramesh Reddy
While trying to use "Teiid Connection >> Source Model" importer with new SOLR source type I encountered
{code}
java.lang.NullPointerException
at org.teiid.designer.teiidimporter.ui.wizard.ShowDDLPage.setVisible(ShowDDLPage.java:201)
at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1259)
at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1238)
at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1227)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1225)
at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:915)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:628)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1392)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3742)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3363)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:826)
at org.eclipse.jface.window.Window.open(Window.java:802)
at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:152)
at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:279)
at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)
at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)
at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)
at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)
at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)
at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:420)
at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1392)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3742)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3363)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
at org.eclipse.equinox.launcher.Main.main(Main.java:1426)
{code}
The dialog did not pop any dialog box about error, nor it can proceed any further, so notification given to user other than he/she can cancel it. But the above is logged in the "errors" panel.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1990:
----------------------------------------
* READ and EXECUTE only
* User enables, then READ is auto-checked
* When both READ and EXECUTE are unchecked, the access check-box is unchecked and READ/EXECUTE are disabled
* User unchecks access check-box, the READ/EXECUTE are disabled
* Will not allow a permission for system access be put into vdb.xml when READ and EXECUTE are false
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
> Fix For: 8.4
>
> Attachments: data-role-editor-system-admin-access.png
>
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1990:
-----------------------------------
Attachment: data-role-editor-system-admin-access.png
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
> Fix For: 8.4
>
> Attachments: data-role-editor-system-admin-access.png
>
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-1990:
----------------------------------------
Only READ and EXECUTE. Users can not alter system metadata.
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
> Fix For: 8.4
>
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1990:
----------------------------------------
So are we sure we want to allow CREATE, UPDATE, DELETE and ALTER of SYSADMIN ? or just READ & EXECUTE?
Seems like a stretch to expect all users to be able to modify system data from any VDB?
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1990:
-----------------------------------
Fix Version/s: 8.4
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
> Fix For: 8.4
>
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-1990:
---------------------------------------
Mimic'ing what's in the VDB.xml would be good, as long as it solves the issue of allowing the user to execute the Sysadmin..refreshMatView()
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1990) There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1990?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1990:
----------------------------------------
The basic VDB Editor has no knowledge of the methods/tables in the System tables. If a server is running, then an admin connection could maybe provide access to that metadata.
Wouldn't be too difficult to add a set of check-boxes to mimic what the vdb.xml file contains for the "system" resource data role when the "Allow this role to access SYSADMIN model" check-box. Basically user could set CRUD + Execute + Alter ??
Anything else would be a major change
> There is no way to edit a vdb's data role for sysadmin by Teiid Desginer
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-1990
> URL: https://issues.jboss.org/browse/TEIIDDES-1990
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 7.8
> Reporter: Van Halbert
> Assignee: Johnathon Lee
>
> Description of problem:
> When user creates a data role for a VDB, only read permission will be added to sysadmin. Thus, user cannot execute SYSADMIN.refreshMatView() by the lucking of the execute permission.
> Version-Release number of selected component (if applicable):
> JBDS 5.0.2.GA
> Teiid Designer 7.7.4.v20130801-1634-H7-Final
> Steps to Reproduce:
> 1. create a VDB
> 2. add a new Data Role and save
> 3. deploy it
> 4. send query to execute SYSADMIN.refreshMatView()
> I modified $JBOSS_HOME/sample/quickstarts/eds_simple_jdbc_client/src/JDBCClient.java to send a query. as follows.
> boolean result = statement.execute(sql);
> System.out.println("result:"+result);
> Actual results:
> **server log**
> 15:23:32,307 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request ZGnGSBd7pxlU.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> 15:23:32,363 WARN [PROCESSOR] Processing exception 'User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.' for request RABFD6OPr5UQ.0. Exception type org.teiid.api.exception.query.QueryValidatorException thrown from org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342). Enable more detailed logging to see the entire stacktrace.
> **client console**
> [hfuruich@dhcp-217-119 eds_simple_jdbc_client]$ ant runtest -Dprompt=true
> Buildfile: /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> jbossesb-quickstart-override:
> jbossesb-source-dependencies:
> compile.simpleclient:
> [javac] /home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as/samples/quickstarts/eds_simple_jdbc_client/build.xml:79: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
> prompt:
> [input] Enter server name or x [exit]: [localhost]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid port or x [exit]: [31000]
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter Teiid VDB or x [exit]: [MarketData]
> SampleVDB
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> [input] Enter sql command x [exit]: [select stock.* from (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock]
> EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [echo] product.dir=/home/hfuruich/product/eds-531/jboss-soa-p-5/jboss-as
> [echo] default
> validate.parm:
> setdefaults:
> runtest:
> [echo] Running Test Query: EXEC SYSADMIN.refreshMatView(viewname=>'TestMySQLView.sample.odatatest', invalidate=>true)
> [java] HOST:PORT:VDB - localhost:31000:SampleVDB
> [java] Executing using the TeiidDriver against VDB: SampleVDB
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] -----------------------------------
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)Executing using the TeiidDataSource against VDB: SampleVDB
> [java]
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:43)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> [java] org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
> [java] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
> [java] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)
> [java] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
> [java] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)
> [java] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
> [java] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
> [java] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:222)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> [java] at java.lang.reflect.Method.invoke(Method.java:597)
> [java] at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:101)
> [java] at com.sun.proxy.$Proxy1.read(Unknown Source)
> [java] at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:356)
> [java] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:556)
> [java] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:318)
> [java] at JDBCClient.execute(JDBCClient.java:75)
> [java] at JDBCClient.main(JDBCClient.java:48)
> [java] Caused by: org.teiid.core.TeiidProcessingException: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <EXECUTE> for 1 or more of the groups/elements/procedures.
> [java] at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:342)
> [java] at org.teiid.dqp.internal.process.DefaultAuthorizationValidator.validate(DefaultAuthorizationValidator.java:50)
> [java] at org.teiid.dqp.internal.process.Request.validateAccess(Request.java:488)
> [java] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402)
> [java] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:469)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
> [java] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> [java] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
> [java] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
> [java] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
> [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
> [java] at java.lang.Thread.run(Thread.java:662)
> BUILD SUCCESSFUL
> Total time: 47 seconds
> Expected results:
> User can edit permission for sysadmin by JBDS, so that SYSADMIN.refreshMatView() can be executed as expected
> Additional info:
> I tried to edit a vdb.xml directly, but there is no file under a teiid project
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-1946) Dialog resticts name characters too much
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1946?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-1946.
------------------------------------
Resolution: Done
Done
> Dialog resticts name characters too much
> ----------------------------------------
>
> Key: TEIIDDES-1946
> URL: https://issues.jboss.org/browse/TEIIDDES-1946
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.3
> Reporter: Steven Hawkins
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 8.4
>
>
> Related to TEIIDDES-570 if I attempt to add a child view to a virtual model, the create dialog restricts the name even if the "valid unquoted sql name" name option is set to ignore.
> If I for example am initially prevented from entering foo! as the name, I can create the view as foo, then change the name in the property editor to foo! without a problem.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0
[JBoss JIRA] (TEIIDDES-2016) Editing column info (name or datatype) in Flat File importer does't update generated SQL statement
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2016?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2016:
--------------------------------------
Assignee: Barry LaFond
> Editing column info (name or datatype) in Flat File importer does't update generated SQL statement
> --------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2016
> URL: https://issues.jboss.org/browse/TEIIDDES-2016
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.3
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.4
>
>
> 1) Import a local Flat File
> 2) On the page defining columns.... rename a column or change datatype
> 3) Generated SQL statement doesn't change.
> You can hit Next > ... then < Back and it'll be updated, but we're missing a call to update the statement.
> Probably missing the same logic in the XML editor as well.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
10 years, 5 months
- 1
- 0