Results 1 to 10 of 10

Thread: xp_fixeddrives

  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: xp_fixeddrives

    Hi everybody,

    Does anyone knows the alternative for xp_fixeddrives or what privilege should i grant to a normal user to execute xp_fixeddrives which returns the disc space details in sql server 2005.

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    add the user to sysadmin role.
    Cheers....

    baburajv

  3. #3
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    Quote Originally Posted by baburajv
    add the user to sysadmin role.
    I don't know if giving EXEC rights to the xp will do the trick but adding the user to sysadmin seems like a bad idea (to say the least!).

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by Lexiflex
    I don't know if giving EXEC rights to the xp will do the trick but adding the user to sysadmin seems like a bad idea (to say the least!).
    No worse than giving the children chain-saws when they play "Hide-and-Seek", is it?

    -PatP

  5. #5
    Join Date
    Jul 2004
    Posts
    34

    xp_fixeddrives

    Its not good to grant sysadmin role to a normal user.


    saju

  6. #6
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    as a matter of fact, i could execute "exec master..xp_fixeddrives" from a login that is neither a member of sysadmin or having assigned any special permission. just a normal user belonging to public role of a particular user-database. this is in sql serv 2000. am i missing something? this user cannot execute sps like sp_addlogin etc. perhaps xp_fixeddrives is left for all!!

  7. #7
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    Hi folks,

    i tried this is SQL serever 2005.

    i created a normal user and executed the xp, the xp returned nothing, no warnings, no error messages.

    wen i tried this as 'sa', the xp returned records.
    now, i added the user, to sysadmin role and tried. the xp returned records this time.

    is there any special permission required in SQL 2005, to execute xps?

    pls comment
    Cheers....

    baburajv

  8. #8
    Join Date
    Jul 2004
    Posts
    34
    Hi,
    It works with normal user in sql server 2000 but not with sql 2005

  9. #9
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    true, but ur issue was in SQL 2005
    Cheers....

    baburajv

  10. #10
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    I believe you want to reference the "EXECUTE AS" clause in 2005 BOL. This should allow you to let joe (or josephine) user execute the XP_FixedDrives sproc from a proc you create for him/her.

    -- This is all just a Figment of my Imagination --

Posting Permissions

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