OraFAQ Forum: Security » column level security :

Home » RDBMS Server » Security » column level security :

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

column level security : [message #20618]

Fri, 07 June 2002 10:57

virish
Messages: 2
Registered: June 2002

Junior Member

Hi all,
Excuse me if I'm posting this in the wrogn place.
But I hope u guys can help me out.

Do u know how to impose column level security in ORACLE?
I want to restrict some of the roles/users to not to see some columns?
I guess Virtual Private Database in Oracle supports only row level security?

Your help is highly appreciated.

Thanks,
Chary

Report message to a moderator

Re: column level security : [message #20619 is a reply to message #20618]

Fri, 07 June 2002 11:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can create customized views ( showing only the required columns).
and allow users / roles acces only these views

Report message to a moderator

Re: column level security : [message #20623 is a reply to message #20618]

Fri, 07 June 2002 14:24

virish
Messages: 2
Registered: June 2002

Junior Member

I could do that!
But the problem is some users/roles have access to all columns
and some others have access to few columns.
And I want to maintain only one view for all the users.

Thanks,

Report message to a moderator

Previous Topic:	Password after initial install 9i
Next Topic:	Verifying database role

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 17:56:00 CST 2025