Securing data in a table ?

  • Thread starter Thread starter François Uldry
  • Start date Start date
F

François Uldry

Hi All,

I got a big table of categorized data.

I need to restrict the ability of my users to access a certain type of data
in that table.

How can I do that ?

Cost table :
ID - long - IDENTITY (1,1)
CostCategory - long - FOREIGN KEY table catagories
Value - real - data
Description - varchar(25) - some text describing the line

Any clue is welcome,
Francois
 
You would have to implement security, and then deny them all permissions on
the table. Create a query set to Run With Owner Permissions. Criteria in
the query could restrict the data seen.
 
Back
Top