locked
how to add permission xp_msver RRS feed

  • Question

  • hi GUyz 

    i need to know how to execute this request please

    Add permission to the func id (ab\my_prod_id); permission needed is “Execute permission on xp_msver” 

    Regards


    k


    • Edited by '''HuuM''' Friday, August 19, 2016 2:06 PM
    Friday, August 19, 2016 2:02 PM

Answers

  • hi,

    use [yourdb]
    GO
    GRANT EXECUTE ON [dbo].[xp_msver] TO [ab\my_prod_id]
    GO
    

    • Marked as answer by '''HuuM''' Sunday, August 21, 2016 5:29 PM
    Friday, August 19, 2016 2:07 PM

All replies

  • hi,

    use [yourdb]
    GO
    GRANT EXECUTE ON [dbo].[xp_msver] TO [ab\my_prod_id]
    GO
    

    • Marked as answer by '''HuuM''' Sunday, August 21, 2016 5:29 PM
    Friday, August 19, 2016 2:07 PM
  • and remote permission please?

    k

    Friday, August 19, 2016 2:09 PM
  • I am not sure about your last question.

    The target (destination server) should have this option enabled -Allow Remote Connections to this server-

    Friday, August 19, 2016 2:17 PM
  • sorry i mean how to revoke the same permission granted above

    k

    Friday, August 19, 2016 2:27 PM
  • sorry i mean how to revoke the same permission granted above

    k

    Hi the GRANT and REVOKE is worth to read from the below links to understand basic

    REVOKE (Transact-SQL)
    https://msdn.microsoft.com/en-us/library/ms187728(v=sql.105).aspx

    GRANT (Transact-SQL)
    https://msdn.microsoft.com/en-us/library/ms187965(v=sql.105).aspx

    Also the similar thread as below.
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bef3bb7a-4d3d-4da3-a20d-798117b46f1f/execute-permission-on-xpmsver?forum=sqlsecurity#8d3840c4-b68a-45d5-92b3-338ba17f0478


    Regards, S_NO "_"

    Friday, August 19, 2016 5:07 PM