[IQUG] SET USER question

Ray Naugle rnaugle at dssolutions.com
Fri Nov 17 07:09:09 MST 2017

Looking at that link, the Example 1 does have the parens on the second list of names, where Example 3 does not.  The Syntax section doesn’t have them, but since Example 1 does, it might imply you could use them.  J


From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Mumy, Mark
Sent: Friday, November 17, 2017 6:03 AM
To: Henderson, William L; IQ Users Group
Subject: Re: [IQUG] SET USER question




Check out the current manuals: https://help.sap.com/viewer/a89a0a8384f21015b1e7adbeca456f73/


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 Mumy

Strategic Technology Incubation Group

Customer Innovation and Enterprise Platform |  SAP

M +1 347-820-2136 | E  <mailto:mark.mumy at sap.com> mark.mumy at sap.com

My Blogs: https://blogs.sap.com/author/markmumy/


 <https://sap.na.pgiconnect.com/I825063> 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 )


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/   and also tried version SAP IQ/, same thing on both.





Will Henderson 


This message is confidential and subject to terms at: 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/4dedcb1f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 178 bytes
Desc: not available
URL: <http://iqug.org/pipermail/iqug/attachments/20171117/4dedcb1f/attachment.png>

More information about the IQUG mailing list