Home » RDBMS Server » Security » Column level Security for application users
icon2.gif  Column level Security for application users [message #185286] Tue, 01 August 2006 00:20 Go to next message
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.

Re: Column level Security for application users [message #185341 is a reply to message #185286] Tue, 01 August 2006 05:06 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't know the answer to that, but workaround might be creating a view which would contain only those columns you want to show.
Previous Topic: i want to retrieve the user domain !!
Next Topic: Creation of New Username & Password in SQL*PLUS?
Goto Forum:
  


Current Time: Fri Dec 09 21:07:34 CST 2016

Total time taken to generate the page: 0.09103 seconds