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.

Updating Field Permissions

2 posts in Visual Basic Last posting was on 2007-10-16 20:55:23.0Z
Jeffrey Bovee Posted on 2007-10-16 17:44:04.0Z
Reply-To: "Jeffrey Bovee" <jbovee@runwithmustang.com>
From: "Jeffrey Bovee" <jbovee@runwithmustang.com>
Newsgroups: advantage.visual_basic
Subject: Updating Field Permissions
Date: Tue, 16 Oct 2007 13:44:04 -0400
Lines: 14
Organization: Mustang Computer Specilists, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 68.32.89.32
Message-ID: <4714f75f@solutions.advantagedatabase.com>
X-Trace: 16 Oct 2007 11:39:43 -0700, 68.32.89.32
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.32.89.32
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:1139
Article PK: 1137932

Is there a way to update field permissions for tables using VB6 code? Using
the 'Grant' command I can update permissions for a table, but is there a way
to update the individual fields.

These fields can be accessed in the Native SQL utility using a 'Select *
from system.permissions where Object_Type = 4' command, but when you try to
update them, it tells you the view is read only. Is there a way to change
this?

Thanks,

Jeffrey Bovee


Edgar Sherman Posted on 2007-10-16 20:55:23.0Z
Date: Tue, 16 Oct 2007 14:55:23 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: advantage.visual_basic
Subject: Re: Updating Field Permissions
References: <4714f75f@solutions.advantagedatabase.com>
In-Reply-To: <4714f75f@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.133
Message-ID: <47152401@solutions.advantagedatabase.com>
X-Trace: 16 Oct 2007 14:50:09 -0700, 10.24.34.133
Lines: 31
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.133
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:1140
Article PK: 1137931

Jeffrey,

You can use Grant to accomplish this.
Here is a link to the help:
http://devzone.advantagedatabase.com/dz/webhelp/Advantage8.1/advantage.htm#supported_statements/grant.htm


For example if you have a table named "customer"
GRANT SELECT( cust_name ), SELECT( address ), UPDATE( balance ) ON
customers TO user1

This would grant select permission to the columns: cust_name & address.
User1 would be able to update column: balance

Edgar Sherman

Jeffrey Bovee wrote:
> Is there a way to update field permissions for tables using VB6 code? Using
> the 'Grant' command I can update permissions for a table, but is there a way
> to update the individual fields.
>
> These fields can be accessed in the Native SQL utility using a 'Select *
> from system.permissions where Object_Type = 4' command, but when you try to
> update them, it tells you the view is read only. Is there a way to change
> this?
>
> Thanks,
>
> Jeffrey Bovee
>
>