OraFAQ Forum: Security » Column level Security for application users

Home » RDBMS Server » Security » Column level Security for application users

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Column level Security for application users [message #185286]

Tue, 01 August 2006 00:20

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

Hi,

I have implemented the column level security in my emp table.It does the masking of salary column of the database users.Please see the following sample example.

[code]
connect system/manager@orcl
system> create or replace function user_fun (p_schema in varchar2,p_object in varchar2)
return varchar2 as
begin
return 'ename=user';
end;
/
function created.
system>begin
dbms_rls.add_policy(object_scehma=>'scott',
object_name=>'emp',
function_name=>'user_fun',
policy_name=>'scott_poli'
function_schema=>'system'
statement_type=>'select'
sec_relevant_cols=>'sal'
sec_relevant_cols_opt=>dbms_rls.all_rows);
end;
/
ploicy created.

system>select * from emp;

eno ename sal
--------------------
1 system 5000
2 scott 2000
3 ram 3000
conn scott/tiger@orcl
scott>select * from emp;
eno ename sal
--------------------
1 system
2 scott 2000
3 ram
[code\]
Here i'm getting the column masking for the database users.But i want to mask the column for form level users,whenever they're login into the form and connecting the forms through the database.Plese give me any idea to retrieve the client_info for forms user.thanks in advance.

Report message to a moderator