| What priviliges? [message #358479] |
Tue, 11 November 2008 09:22  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
