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.

read only connection to an advantage database (ADD)

2 posts in ODBC Last posting was on 2010-05-06 18:12:08.0Z
StevenL Posted on 2010-05-06 00:21:46.0Z
From: "StevenL" <steve.lipson@aurorabankfsb.com>
Subject: read only connection to an advantage database (ADD)
Newsgroups: Advantage.ODBC
Date: Thu, 6 May 2010 01:21:46 +0100
X-Priority: 3
X-Library: Indy 9.00.10
X-Newsreader: <dedXmlGateway>
NNTP-Posting-Host: 88.198.32.147
Message-ID: <4be1f5c1@solutions.advantagedatabase.com>
X-Trace: 5 May 2010 16:48:33 -0700, 88.198.32.147
Lines: 12
Path: solutions.advantagedatabase.com!88.198.32.147
Xref: solutions.advantagedatabase.com Advantage.ODBC:1880
Article PK: 1133257

I have a 3rd party application that uses advantage as it's back end. The
3rd party application does not use any security on the advantage
database so currently anyone with an ODBC connection can read/write to
the tables. I have created an advantage database (ADD) and added some
of the tables. I have the check rights option set on the database. I
only have read access on the windows directory where the files are
located. I can still update the tables even though the check rights
option is set. Is there some other setting I need to check? Any help!



--- posted by geoForum on http://www.newswhat.com


Edgar Sherman Posted on 2010-05-06 18:12:08.0Z
Date: Thu, 06 May 2010 12:12:08 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: Advantage.ODBC
Subject: Re: read only connection to an advantage database (ADD)
References: <4be1f5c1@solutions.advantagedatabase.com>
In-Reply-To: <4be1f5c1@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <4be305e2@solutions.advantagedatabase.com>
X-Trace: 6 May 2010 12:09:38 -0700, 10.24.34.164
Lines: 28
Path: solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.ODBC:1881
Article PK: 1133256

Where are you setting check rights? In the Dictionary properties or in
the connection string?

The Connection string is only applicable to free-tables, not
dictionaries. For dictionaries you need to set the dictionary property
to verify access rights / check user rights. You can do this by using
ARC and looking at the Dictionary properties under the "Security" tab,
or use sp_ModifyDatabase('VERIFY_ACCESS_RIGHTS', 'TRUE'); Then create a
user (or group and add a user to the group) with only select permission
on the table.

http://devzone.advantagedatabase.com/dz/WebHelp/Advantage9.1/advantage_sql/system_procedures/procedures/sp_modifydatabase.htm

Edgar

On 5/5/2010 6:21 PM, StevenL wrote:
> I have a 3rd party application that uses advantage as it's back end. The
> 3rd party application does not use any security on the advantage
> database so currently anyone with an ODBC connection can read/write to
> the tables. I have created an advantage database (ADD) and added some
> of the tables. I have the check rights option set on the database. I
> only have read access on the windows directory where the files are
> located. I can still update the tables even though the check rights
> option is set. Is there some other setting I need to check? Any help!
>
>
>
> --- posted by geoForum on http://www.newswhat.com