July 17th, 2009

Data Control Language, VIEW Security (Part 1 of 2)

Posted by admin in R. Data Control Language

Using a view to restrict column access:

 

Here the user, ACTGUSER, has been given SELECT privileges on the EMPLOYEE_VIEW.
But this does not give ACTGUSER any access privileges to the base table EMPLOYEE_TBL,
so ACTGUSER can not access RATE_HOUR information.

Comments are closed.

Sorry, the comment form is closed at this time.