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.

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

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.