blocking informatuin in dbc views

Database

blocking informatuin in dbc views

where i can get blocking information in dbc views?
1 REPLY
N/A

Re: blocking informatuin in dbc views

Hi

I 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...