Object level Authorisation

From: Fulvio (fulvio_at_nssitaly.com)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 15:25:46 +0100

Hi all,

is there a way to tell Sql Server to return Null values if user has no
SELECT authorisation on a column ?

let's imagine a table structure like:

Tps_Id,
Tps_Name,
Tps_Price

Now in my VB application i use 'Select * from Tps'

All works fine for users in roles that can select data on that table. But if
i have a role which can't select column Tps_Price i get error 230.
I'd prefere not to change VB code by looking for user's role and differently
query DB

Thanks for your help 

-- 
Fulvio

Relevant Pages

  • Re: OT : Good XP Domain Admin book?
    ... but he's not going to run MS SQL server on linux... ... > As to what I'd imagine - I have no idea. ... > expertise etc etc. Oracle, Oracle XE, DB2, PostgreSQL are all options. ...
    (uk.rec.motorcycles)
  • TFields and column permissions
    ... When you have a table in SQL Server and you drop "select access" to some ... Imagine you have an ADOTable attached to a given table, ... would be automatically removed from the ADOTable and from the grid. ... log as "admin" I would be able to see everything. ...
    (borland.public.delphi.database.ado)
  • Re: C#, ADO.NET and MS-SQL
    ... > as Sql Server read transactions only lock each row as the ... > performance tuning is so critical and demanding for Oracle (you can imagine ... I would have thought integrity would be vital to pretty much *every* ...
    (microsoft.public.dotnet.languages.csharp)
  • [ot] MS SQL and Access - connection usage
    ... We have an application which used to be a straight MS access database, ... to 6 connections to the SQL database. ... can imagine that things are beginning to creak. ... Knowing more about Oracle than I do about SQL Server, ...
    (uk.rec.motorcycles)
  • Re: Specialist groups
    ... > In the crazy world we live in that appears to be the case. ... Imagine, you ... get your authorisation and come up here and paddle on the ... The local Leader has to hold 3 Star, ...
    (uk.rec.scouting)