Re: Can SQL Users have Access to A Win2k Share?

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 06/25/03

  • Next message: cengiz: "script object-level permissions"
    Date: Wed, 25 Jun 2003 10:05:18 +0200
    
    

    Yes, they can use so-called proxy account for the xp_cmdshell operations.
    Check the "xp_sqlagent_proxy_account" topic in Books OnLine
    (mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ts
    qlref.chm::/ts_xp_aa-sz_8sdm.htm).

    -- 
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: http://www.sqlserverfaq.com
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org
    "Luis Wiedemann" <luis.wiedemann@florence[antispam]bank.com> wrote in
    message news:e4hQ12bODHA.2316@TK2MSFTNGP12.phx.gbl...
    > Hello All!
    > Because we use Netware and eDirectory for our directory services, we
    > installed SQL 2000 SP3 to not use Windows and SQL user account info, but
    > rather just the SQL user info. Now, because of a misunderstanding and lack
    > of competence from our service provider/data center, we have implemented a
    > new mission critical application that for some reason needs to see a share
    > on the server. No drives need to be mapped, it just seems that it wants to
    > know its there, then do its thing...is there a way to give sql users
    access
    > to a share? I would really hate having to deal with eDirectory in a mixed
    > environment!
    >
    > TIA
    >
    > Luis
    >
    >
    

  • Next message: cengiz: "script object-level permissions"