What priviliges? [message #358479] |
Tue, 11 November 2008 09:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
meo_beo
Messages: 12 Registered: September 2008
|
Junior Member |
|
|
Hi, if I want a particular user to view the data of just a part of a table, what will I have to do? If I grant a Table Object privilige to that user, it can only help me let that user select, insert, update... the data of a whole table, which is not what I want to do. Is there any way to, for example, allow a DB user to view only the customers whose ID smaller than 10 of the customer table?
|
|
|
Re: What priviliges? [message #358491 is a reply to message #358479] |
Tue, 11 November 2008 09:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68679 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | if I want a particular user to view the data of just a part of a table, what will I have to do?
|
Create a view that restrict the rows to the one allowed and grant privilege on this view not on the table.
Regards
Michel
|
|
|