All Forums Database
veeraiah 1 post Joined 06/06
18 Oct 2006
blocking informatuin in dbc views

where i can get blocking information in dbc views?

XTUPIE 42 posts Joined 11/05
26 Oct 2006

HiI am not sure what blocking information you are looking for. Normally a view is a subset of a table contain the fields you want everyone to view. ie. you may want to allow people to view employee names but not their address, telephone and salary information, thus you would create a view only on the employee names and suranme fields.Remmeber that you also control the access rights of the table / view so you can revoke all access from the table and create two vies one for the names and one for HR, who need to see the address detaisl etc. Then you grant access to either a role (preferred option) or to individual users.I trust this helps, esle contact me...


You must sign in to leave a comment.