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.

synonyms in Sybase

3 posts in General Discussion Last posting was on 2009-04-01 18:08:25.0Z
Nick Nocerino Posted on 2009-04-01 16:46:56.0Z
From: "Nick Nocerino" <nnocerino@mysck.com>
Newsgroups: ianywhere.public.general
Subject: synonyms in Sybase
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d39a80$1@forums-1-dub>
Date: 1 Apr 2009 08:46:56 -0800
X-Trace: forums-1-dub 1238604416 10.22.241.152 (1 Apr 2009 08:46:56 -0800)
X-Original-Trace: 1 Apr 2009 08:46:56 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7463
Article PK: 5874

All,

I have run into an issue. I have created a new user in my Sybase 10.0.1
database. This user has dba permission but is not the owner of any database
objects. I have then setup that user information in our webapp
(username/password), but now all the SQL in the app will not return any info
against the database. The issue is that all the sql queries do not have the
owner identified so now I get errors like "Table User not found". Does
anyone have any suggestions on what to do? Does Sybase have the concept of
synonyms like Orale does?

Thanks,
Nick


Josh Savill [Sybase] Posted on 2009-04-01 17:08:31.0Z
From: "Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: synonyms in Sybase
References: <49d39a80$1@forums-1-dub>
In-Reply-To: <49d39a80$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d39f8f$1@forums-1-dub>
Date: 1 Apr 2009 09:08:31 -0800
X-Trace: forums-1-dub 1238605711 10.22.241.152 (1 Apr 2009 09:08:31 -0800)
X-Original-Trace: 1 Apr 2009 09:08:31 -0800, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7464
Article PK: 5879

Nick,

It's been a while since I've tried this, but make the Owner of the database tables into a Group.
Then grant the new user part of the Group. I believe this will provide sufficient permissions to
access the tables.

Let me know if it works.

--
Joshua Savill
Sybase Inc. - Product Manager

Nick Nocerino wrote:
> All,
>
> I have run into an issue. I have created a new user in my Sybase 10.0.1
> database. This user has dba permission but is not the owner of any database
> objects. I have then setup that user information in our webapp
> (username/password), but now all the SQL in the app will not return any info
> against the database. The issue is that all the sql queries do not have the
> owner identified so now I get errors like "Table User not found". Does
> anyone have any suggestions on what to do? Does Sybase have the concept of
> synonyms like Orale does?
>
> Thanks,
> Nick
>
>


Nick Nocerino Posted on 2009-04-01 18:08:25.0Z
From: "Nick Nocerino" <nnocerino@mysck.com>
Newsgroups: ianywhere.public.general
References: <49d39a80$1@forums-1-dub> <49d39f8f$1@forums-1-dub>
Subject: Re: synonyms in Sybase
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d3ad99@forums-1-dub>
Date: 1 Apr 2009 10:08:25 -0800
X-Trace: forums-1-dub 1238609305 10.22.241.152 (1 Apr 2009 10:08:25 -0800)
X-Original-Trace: 1 Apr 2009 10:08:25 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7465
Article PK: 5878

Joshua,

Worked great thanks!

Nick Nocerino

"Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com> wrote in message
news:49d39f8f$1@forums-1-dub...
> Nick,
>
> It's been a while since I've tried this, but make the Owner of the
> database tables into a Group. Then grant the new user part of the Group. I
> believe this will provide sufficient permissions to access the tables.
>
> Let me know if it works.
>
> --
> Joshua Savill
> Sybase Inc. - Product Manager
>
>
> Nick Nocerino wrote:
>> All,
>>
>> I have run into an issue. I have created a new user in my Sybase 10.0.1
>> database. This user has dba permission but is not the owner of any
>> database objects. I have then setup that user information in our webapp
>> (username/password), but now all the SQL in the app will not return any
>> info against the database. The issue is that all the sql queries do not
>> have the owner identified so now I get errors like "Table User not
>> found". Does anyone have any suggestions on what to do? Does Sybase
>> have the concept of synonyms like Orale does?
>>
>> Thanks,
>> Nick