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.

Sybase 8

4 posts in General Discussion Last posting was on 2005-05-04 18:02:24.0Z
Joshua Posted on 2005-05-04 02:14:46.0Z
Sender: 308c.42782ff9.1804289383@sybase.com
From: Joshua
Newsgroups: ianywhere.public.general
Subject: Sybase 8
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42783012.308f.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 May 2005 19:14:42 -0700, 10.22.241.42
Lines: 15
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 May 2005 19:14:43 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 May 2005 19:14:46 -0700
X-Trace: forums-1-dub 1115172886 10.22.108.75 (3 May 2005 19:14:46 -0700)
X-Original-Trace: 3 May 2005 19:14:46 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4439
Article PK: 8249

We have a database (sybase asa 8) with a powerbuilder front
end application. the application connects to the datbase
througth the sybase odbc connection that we set up. It uses
the default username DBA and password SQL. The application
is an in-scope SOX application so we had to figure out a new
way to connect to the database since it was found to be a
security violation. Here is the problem. Several of the
tables in the application are mapped to the dba username.
For example, the table bankers is acutally dba.bankers. If
we change the username that connects to the datbase, we
recieve an error that the table cannot be found. We are
trying to avoid having to correct the over 800 instances of
this. Any ideas?

Joshua


Breck Carter [TeamSybase] Posted on 2005-05-04 10:27:24.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Sybase 8
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <uh8h71pks5itaermdk69crne89nio1j9p9@4ax.com>
References: <42783012.308f.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.254.244.99
X-Original-NNTP-Posting-Host: 208.254.244.99
Date: 4 May 2005 03:27:24 -0700
X-Trace: forums-1-dub 1115202444 208.254.244.99 (4 May 2005 03:27:24 -0700)
X-Original-Trace: 4 May 2005 03:27:24 -0700, 208.254.244.99
Lines: 34
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4440
Article PK: 8248

GRANT GROUP TO DBA;
GRANT MEMBERSHIP IN GROUP DBA TO OTHER;

That allows user OTHER to "see" tables owned by DBA without explicitly
specifying "DBA.tablename".

The user OTHER does *not* inherit the DBA privilege from DBA.

Breck

On 3 May 2005 19:14:46 -0700, Joshua wrote:

>We have a database (sybase asa 8) with a powerbuilder front
>end application. the application connects to the datbase
>througth the sybase odbc connection that we set up. It uses
>the default username DBA and password SQL. The application
>is an in-scope SOX application so we had to figure out a new
>way to connect to the database since it was found to be a
>security violation. Here is the problem. Several of the
>tables in the application are mapped to the dba username.
>For example, the table bankers is acutally dba.bankers. If
>we change the username that connects to the datbase, we
>recieve an error that the table cannot be found. We are
>trying to avoid having to correct the over 800 instances of
>this. Any ideas?
>
>Joshua

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


Joshua Posted on 2005-05-04 13:56:16.0Z
Sender: 63f3.4278d04a.1804289383@sybase.com
From: Joshua
Newsgroups: ianywhere.public.general
Subject: Re: Sybase 8
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4278d480.644f.1681692777@sybase.com>
References: <uh8h71pks5itaermdk69crne89nio1j9p9@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 May 2005 06:56:16 -0700
X-Trace: forums-1-dub 1115214976 10.22.241.41 (4 May 2005 06:56:16 -0700)
X-Original-Trace: 4 May 2005 06:56:16 -0700, 10.22.241.41
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4443
Article PK: 8252

So are you suggesting that we convert the DBA user to a
group and then make the OTHER user a member of that group?

> GRANT GROUP TO DBA;
> GRANT MEMBERSHIP IN GROUP DBA TO OTHER;
>
> That allows user OTHER to "see" tables owned by DBA
> without explicitly specifying "DBA.tablename".
>
> The user OTHER does *not* inherit the DBA privilege from
> DBA.
>
> Breck
>
> On 3 May 2005 19:14:46 -0700, Joshua wrote:
>
> >We have a database (sybase asa 8) with a powerbuilder
> front >end application. the application connects to the
> datbase >througth the sybase odbc connection that we set
> up. It uses >the default username DBA and password SQL.
> The application >is an in-scope SOX application so we had
> to figure out a new >way to connect to the database since
> it was found to be a >security violation. Here is the
> problem. Several of the >tables in the application are
> mapped to the dba username. >For example, the table
> bankers is acutally dba.bankers. If >we change the
> username that connects to the datbase, we >recieve an
> error that the table cannot be found. We are >trying to
> avoid having to correct the over 800 instances of >this.
> Any ideas? >
> >Joshua
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Chris Keating (iAnywhere Solutions) Posted on 2005-05-04 18:02:24.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <uh8h71pks5itaermdk69crne89nio1j9p9@4ax.com> <4278d480.644f.1681692777@sybase.com>
Subject: Re: Sybase 8
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <42790e2a$1@forums-2-dub>
X-Original-Trace: 4 May 2005 11:02:18 -0700, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 May 2005 11:02:21 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 May 2005 11:02:24 -0700
X-Trace: forums-1-dub 1115229744 10.22.108.75 (4 May 2005 11:02:24 -0700)
X-Original-Trace: 4 May 2005 11:02:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4448
Article PK: 8257

That is correct.

<Joshua> wrote in message news:4278d480.644f.1681692777@sybase.com...
> So are you suggesting that we convert the DBA user to a
> group and then make the OTHER user a member of that group?
>
>> GRANT GROUP TO DBA;
>> GRANT MEMBERSHIP IN GROUP DBA TO OTHER;
>>
>> That allows user OTHER to "see" tables owned by DBA
>> without explicitly specifying "DBA.tablename".
>>
>> The user OTHER does *not* inherit the DBA privilege from
>> DBA.
>>
>> Breck
>>
>> On 3 May 2005 19:14:46 -0700, Joshua wrote:
>>
>> >We have a database (sybase asa 8) with a powerbuilder
>> front >end application. the application connects to the
>> datbase >througth the sybase odbc connection that we set
>> up. It uses >the default username DBA and password SQL.
>> The application >is an in-scope SOX application so we had
>> to figure out a new >way to connect to the database since
>> it was found to be a >security violation. Here is the
>> problem. Several of the >tables in the application are
>> mapped to the dba username. >For example, the table
>> bankers is acutally dba.bankers. If >we change the
>> username that connects to the datbase, we >recieve an
>> error that the table cannot be found. We are >trying to
>> avoid having to correct the over 800 instances of >this.
>> Any ideas? >
>> >Joshua
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> Buy the book:
>>
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> bcarter@risingroad.com
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com