Role Question

Create different views against the base table ,then grant the neccessary privileges to your different roles for the coresponding views. Finally, grant the roles to the accounts that need to see the data within the views.
hth ~Jim

On 16 Dec 1999 16:36:13 -0600, zaybx_at_hotmail.com (gigadud) wrote:

>Is there anyway to create a role that will allow only row level
>access.
>
>If i have 5 branches and branch 1 is assigned to a role i only want
>branch 1 to see there records at the same time if a person logging
>into the system belongs to all 5 roles i would llike to give them
>acces to all data.
>
>Any thoughts on this ?
>-Don-
Received on Thu Dec 16 1999 - 20:36:51 CST