RE: Issues with revoking rights to run xp_fileexist?

From: Peter Yang [MSFT] (petery_at_online.microsoft.com)
Date: 07/15/03 

Date: Tue, 15 Jul 2003 07:15:08 GMT

Hello Peter,

Thank you for your posting.

If I understand this correctly, you would like to limit permssions to some
stored procdures so that only authorized users can run them.

You can change this permission in Enterprise Manager or by running some
commands in query analyzier.

In Enterprise Manager, you can cofigure "Execute" permissions of stored
procedures for users and roles in your database.

Also, you can use the following command:

Revoke Execute on <store procedure name> from <user or role name>

For example: Revoke Execute on foobar from public

If you have further questions on the issue, please feel free to post back.

Thanks & Regards,

Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: Peter A. Schott <pschott@drivefinancial.com>
| Subject: Issues with revoking rights to run xp_fileexist?
| Date: Mon, 14 Jul 2003 16:18:38 -0500
| Message-ID: <0f76hv4pj4dqsuede7dbv7aog5bmr0an3v@4ax.com>
| X-Newsreader: Forte Agent 1.93/32.576 English (American)
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: drivefinancial.com 65.105.152.62
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.security:14506
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| While I don't see any issues with this off the top of my head, I'd like to
| limit access to this proc so that public can't run it - only SysAdmins or
| higher-level users (as needed).
|
| Are there any caveats to limiting access to this proc?
|
| Thanks in advance.
|
| -Peter Schott
|

Relevant Pages

  • Re: Im back!
    ... from the official RMMGA site that the group was now able to read messages ... It took a while to realize it was Dorgan prankin' me but I'm back. ... Peter, Yea Tom from Texas quit posting,Dunwell went brokeback on Sorell! ...
    (rec.music.makers.guitar.acoustic)
  • Re: Unplug a scsi drive and boot dies
    ... Top Posting - Yawn ... Peter Peter the Pussy Eater. ... I'm not the one that cares about spelling. ... It sucks 200 messages at a time. ...
    (comp.os.linux.setup)
  • Re: Losing Delegated rights
    ... This posting is provided "AS IS" with no warranties, ... > Peter Carroll wrote: ... >>>auditing as a means of catching the change. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Problems with Microsoft SAP adapter for BizTalk 2004
    ... This posting is provided "AS IS" with no warranties, ... "Peter Timkó" wrote in message ... > I've generated the schema from SAP with the adapter and i didn't do any ... >>> HEADERPROPOSAL structure without writing a pipeline component to do ...
    (microsoft.public.biztalk.general)