Securing data in a table ?

[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

 

[Joan Wild]

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.