Partition tables and Privileges...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Partition tables and Privileges...

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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

  2. #2
    Join Date
    Jun 2000
    Posts
    117
    Its all or nothing.

    You'll need to create a view on top of the partition and then grant the privileges on the view.
    E. Yen
    OCP DBA 8, 8i, 9i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width