SQL Server Performance

xp_cmdshell permissions

Discussion in 'General DBA Questions' started by tsusanto, Mar 9, 2004.

  1. tsusanto New Member

    How do I see who has permission to execute xp_cmdshell?
    btw..this forum can be very addictive...
    tsusanto, Mar 9, 2004
    #2

  2. Raulie New Member

    Open Master database, extended stored procedures and right click on properties for xp_cmdshell.
    Raulie, Mar 9, 2004
    #2

  3. agavilow New Member

    Hi,

    Go to Enterprise Manager>Databases>master db.>Extended Stored Procedures.
    Right click on xp_cmdshell sp.> All Tasks>Manage Permissions

    or you can use this query from QA:
    select u.name from syspermissions p,sysusers u
    where p.id =(object_id('xp_cmdshell'))
    and u.uid = p.grantee



    Alex
    agavilow, Mar 9, 2004
    #2

  4. satya Moderator

    By default, only members of the sysadmin fixed server role can execute this extended stored procedure. You may, however, grant other users permission to execute this stored procedure.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 9, 2004
    #2

Share This Page