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.

database scheme

3 posts in Commercial ISV's Last posting was on 2009-08-19 19:53:37.0Z
Ontsnapt Posted on 2009-08-19 08:35:32.0Z
From: Ontsnapt <ontsnapt@hotmail.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.commercial-isv.general
Subject: database scheme
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: <4a8bb954@forums-1-dub>
Date: 19 Aug 2009 01:35:32 -0700
X-Trace: forums-1-dub 1250670932 10.22.241.152 (19 Aug 2009 01:35:32 -0700)
X-Original-Trace: 19 Aug 2009 01:35:32 -0700, vip152.sybase.com
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:316
Article PK: 104028

I was wondering if the database scheme should be protected so that users
(competitors) can't see it. Competitors could have a benefit if they can
recreate the database.

If you think it should be protected, what is the best way to do so. If
not, why not?

Thanks
Eric


Roland Smith [TeamSybase] Posted on 2009-08-19 19:53:37.0Z
From: "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com>
Newsgroups: sybase.public.commercial-isv.general
References: <4a8bb954@forums-1-dub>
Subject: Re: database scheme
Lines: 15
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.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8c5841$2@forums-1-dub>
Date: 19 Aug 2009 12:53:37 -0700
X-Trace: forums-1-dub 1250711617 10.22.241.152 (19 Aug 2009 12:53:37 -0700)
X-Original-Trace: 19 Aug 2009 12:53:37 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:318
Article PK: 104029

You can use SQLite with encryption. That would work well for a single user
database.

Go to this page and scroll down to where it says: SQLite2009 Pro Enterprise
Manager

http://osenxpsuite.net/?xp=3&uid=managementtools

It is a SQLite management tool. It is kind of quirky like most SQLite tools
but the cool part is that it comes with an ODBC driver with the SQLite
engine built in. It also supports encrypted databases.

Plus the whole thing is free.


M. Searer Posted on 2009-08-19 18:44:43.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <4a8bb954@forums-1-dub>
In-Reply-To: <4a8bb954@forums-1-dub>
Subject: Re: database scheme
Lines: 17
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8c481b$2@forums-1-dub>
Date: 19 Aug 2009 11:44:43 -0700
X-Trace: forums-1-dub 1250707483 10.22.241.152 (19 Aug 2009 11:44:43 -0700)
X-Original-Trace: 19 Aug 2009 11:44:43 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:317
Article PK: 104030

A reason why not is that by having an 'open' database that the customer can access via reporting tools is that they can access it
via reporting tools and write their own reports.

if you are going to protect it, then you need to prevent the user from accessing it entirely except for your application. All
backups would have to be secured as well. sql anywhere is the only one i've seen that people do this with - pretty sure that ADP
(payroll company) does this.

"Ontsnapt" <ontsnapt@hotmail.com> wrote in message news:4a8bb954@forums-1-dub...
>I was wondering if the database scheme should be protected so that users (competitors) can't see it. Competitors could have a
>benefit if they can recreate the database.
>
> If you think it should be protected, what is the best way to do so. If not, why not?
>
> Thanks
> Eric