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

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.

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. :cool:

Here is an example and demo of fgac: Oracle DBMS_RLS Fine Grained Access Control Virtual Private Database (http://www.psoug.org/reference/fgac_demo.html)


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