How can I hide some data

ScottGem · Feb 9, 2007, 10:56 AM

Create views that only show the data you want to make available to that group of users. Then give them access to the view, not the underlying table.

tikitime · Mar 27, 2007, 07:45 PM

Quote:

Originally Posted by emil255

How can I hide some data in the table from different users< another way <, I like to some user see only part of data

What release are you using?

If you are using 10G, Row Level security and Fine grained access control is what you need. Do a search on dbms_rls and you'll find lots of info.

Here is an example and demo of fgac: Oracle DBMS_RLS Fine Grained Access Control Virtual Private Database

Or, as the previous poster mentioned, create a view that only shows the data that you wish to show that usergroup.

How can I hide some data

Add your answer here.

Check out some similar questions!