[IQUG] SET USER question

Mumy, Mark mark.mumy at sap.com
Fri Nov 17 06:03:22 MST 2017


Will,

Check out the current manuals: https://help.sap.com/viewer/a89a0a8384f21015b1e7adbeca456f73/16.1.2.0/en-US/a3e47b0784f21015bce591841ce8d14b.html

The syntax you have is slightly incorrect.  There are no parens around the second list of names, the TO list.

This is the correct syntax:

1> grant set user (m1) to m2

2> go

1> grant set user (m1,m2) to m3,m4

2> go




Mark

Mark Mumy
Strategic Technology Incubation Group
Customer Innovation and Enterprise Platform |  SAP
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: https://blogs.sap.com/author/markmumy/

https://sap.na.pgiconnect.com/I825063
Conference tel: 18663127353,,8035340905#

From: "iqug-bounces at iqug.org" <iqug-bounces at iqug.org> on behalf of William Henderson <william.l.henderson at jpmorgan.com>
Date: Friday, November 17, 2017 at 04:34
To: "iqug at iqug.org" <iqug at iqug.org>
Subject: [IQUG] SET USER question

Does anyone know how to get GRANT SET USER working?

GRANT SET USER ( PACCOUNTDBO ) TO ( precip_account )
gives
Msg 102, Level 15, State 0
SQL Anywhere Error -131: Syntax error near '(' on line 1

According to the manual the syntax should work: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01774.1601/doc/html/rhi1328732551437.html

Have tried a few variations but no joy.

Version SAP IQ/16.1.020.549/10599/P/sp02.01   and also tried version SAP IQ/16.0.0.808/150311/P/sp08.29, same thing on both.

Thanks
Will


Will Henderson


This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer<http://www.jpmorgan.com/emaildisclaimer> including on confidentiality, legal privilege, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20171117/d2db6b92/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 515 bytes
Desc: image002.png
URL: <http://iqug.org/pipermail/iqug/attachments/20171117/d2db6b92/attachment-0001.png>


More information about the IQUG mailing list