Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    67

    Unanswered: how to revke drop privileges from table OWNER on db2

    Hi All,

    db2 v9.7
    aix 7.1

    my question is how we can revoke the drop privileges from OWNER of table ?

    Thank you in advance for your help

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Have you tried to read the docs on the DROP statement?
    There is no way to do this except transfering the table ownership to another user and revoking any other privileges mentioned there if this user has them.
    Regards,
    Mark.

  3. #3
    Join Date
    Jan 2010
    Posts
    67
    Thank you Mark for your reply and really appreciate,
    I did and I had reached to your comment. now I am %100 sure what should I do.

    Thanks

Posting Permissions

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