July 20th, 2009
Data Control Language, VIEW Security (Part 2 of 2)
Posted by
admin in
R. Data Control Language
Using a view to restrict row access:
 
Â
Here the user, JAMES, has been given SELECT, INSERT, UPDATE, and DELETE privileges on the MANAGER_VIEW, while PATRICK has the same privileges on the EMPLOYEE_VIEW. But this does not give either JAMES or PATRICK any access privileges to the base table EMPLOYEE_TBL.
