Kumaresh Goplsamy

 Profile Answers by Kumaresh Goplsamy 

• Jul 25th, 2007

 

HI,

   It is a security implemented by the supervisor for accessing particular data from the database .

 This can be done by
1.login to BO supervisor .
2.Go to universe tab
3.select the user or group
4.select the universe  in the universe tab
5. Press ctrl+entr  or right click and select properties

6.select the row tab.

7.add the condition

  for example consider emp table in scott user,if the user or group want to see  data only   when the deptno=10 

we can specify by

 table                  -->  scott.emp
 where  Clause  ---> scott.emp.deptno=10

-----------------------------
Thanks & Regards, 
Kumaresh Gopalsamy
 

sri_emd

 Profile Answers by sri_emd 

• Jul 29th, 2010

 

The measure of specifying which rows a user can retrieve based on a column of data or combination of columns is called row level security