Home » RDBMS Server » Security » column level security :
column level security : [message #20618] Fri, 07 June 2002 10:57 Go to next message
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
Re: column level security : [message #20619 is a reply to message #20618] Fri, 07 June 2002 11:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10702
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
Re: column level security : [message #20623 is a reply to message #20618] Fri, 07 June 2002 14:24 Go to previous message
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,
Previous Topic: Password after initial install 9i
Next Topic: Verifying database role
Goto Forum:
  


Current Time: Thu May 26 16:28:33 CDT 2022