Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    133

    Unanswered: running reorg rebuild on other user without SA role

    hi guys,
    would there be a way to grant user without sa_role to run reorg rebuild on a particular table? alias is not option.

    Hoping for your inputs..

    TIA

  2. #2
    Join Date
    Feb 2013
    Posts
    1

    running reorg rebuild on other user without SA role

    Quote Originally Posted by makecompile View Post
    hi guys,
    would there be a way to grant user without sa_role to run reorg rebuild on a particular table? alias is not option.

    Hoping for your inputs..

    TIA
    Hello,

    You have to sa_role or object owner then you can run reorg rebuild

    Thanks,
    Mandar

Posting Permissions

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