[IQUG] SET USER question

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


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 mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: https://blogs.sap.com/author/markmumy/

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<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