Partition tables and Privileges...

Hi,

Is there any way to grant privileges only on one of the partition of a table...?? Is it possible???

Or do I have to create view based on partition and grant privileges on it?

Thanks

Sameer

Its all or nothing.

You'll need to create a view on top of the partition and then grant the privileges on the view.