Home » RDBMS Server » Server Administration » What priviliges? (RedHat 4 EL)
What priviliges? [message #358479] Tue, 11 November 2008 09:22 Go to next message
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
Michel Cadot
Messages: 64153
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
Previous Topic: Undo retention value
Next Topic: Add datafile to UNDO, then remove datafile again
Goto Forum:
  


Current Time: Sun Dec 11 06:17:57 CST 2016

Total time taken to generate the page: 0.13518 seconds