Hi there...

First of all why you want to use only one table??? bcos SQL 7 allows quite a big number of tables so it is always better to use well defined database. still if you want to use only one table you can make as many views as your Offices/Departments are Ex create view1 as select * from table1 where Dept = 'Admin', create view2 as select * from table1 where Dept = 'Sales' and then give select permissions to specific dept accordingly.

regards,
zak


------------
Aaron at 9/10/99 8:39:04 AM

I'm new to SQL 7.0 and have a basic security question. I want to set up security so that different roles can see different portions of the same tables. In other words, Department A see's its projects from table 1 and Department B users see only their projects from table 1. The results are then linked to the client front end, so that the basic form they input/read off will give them the results from table 1 with only their projects. Is there a simple way to do this with a stored procedure or view, so that the result set can be linked to the form and only differs depending on the role? Thanks for the help.