Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASE to IQ

2 posts in General Discussion Last posting was on 2013-01-31 14:54:47.0Z
Jay Posted on 2013-01-23 18:15:01.0Z
Sender: 3a23.510026e2.1804289383@sybase.com
From: Jay
Newsgroups: sybase.public.iq
Subject: ASE to IQ
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <510028a5.3b00.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 Jan 2013 10:15:01 -0800
X-Trace: forums-1-dub 1358964901 172.20.134.41 (23 Jan 2013 10:15:01 -0800)
X-Original-Trace: 23 Jan 2013 10:15:01 -0800, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4596
Article PK: 1159275

Hi

Could anyone advise on below

- IQ table create as user1
- ASE proxy table1 created as dbo (creating exiisting table)
- ASE user1 created as external login
- ASE user1 able to select from proxy table1
- ASE user2, user3 create in ase_group
- ASE proxy table1 granted select permissions to group
ase_group
- ASE user2 unable to select from proxy table1

Basically does each user in the ase group have to be created
as exrternal log in to IQ to be able to see the data in IQ?

Thanks


Remi Posted on 2013-01-31 14:54:47.0Z
Sender: 692f.510a83f9.1804289383@sybase.com
From: Remi
Newsgroups: sybase.public.iq
Subject: Re: ASE to IQ
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <510a85b7.6a00.1681692777@sybase.com>
References: <510028a5.3b00.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Jan 2013 06:54:47 -0800
X-Trace: forums-1-dub 1359644087 172.20.134.41 (31 Jan 2013 06:54:47 -0800)
X-Original-Trace: 31 Jan 2013 06:54:47 -0800, 172.20.134.41
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4599
Article PK: 1307404

Hi,
In your case, I would suggest to use a role instead of a
group :

create role iq_select_role

sp_addexternlogin iq_server, null, iq_user,
pass_for_iq_user, iq_select_role

then grant role iq_select_role to user1, user2 and user3 (
with default on)
and finally,
grant select on proxy_table_iq to iq_select_role.

Regards,
Remi.

> Hi
>
> Could anyone advise on below
>
> - IQ table create as user1
> - ASE proxy table1 created as dbo (creating exiisting
> table) - ASE user1 created as external login
> - ASE user1 able to select from proxy table1
> - ASE user2, user3 create in ase_group
> - ASE proxy table1 granted select permissions to group
> ase_group
> - ASE user2 unable to select from proxy table1
>
> Basically does each user in the ase group have to be
> created as exrternal log in to IQ to be able to see the
> data in IQ?
>
> Thanks