Professional Web Applications Themes

sp_OACreate permissions in SQL Server 2000. - Microsoft SQL / MS SQL Server

Mat, Any reasons for not using SQL mail ( master..xp_sendmail ) ? -- Dinesh. SQL Server FAQ at [url]http://www.tkdinesh.com[/url] "Mat" <mat.hornntlworld.com> wrote in message news:eK2SbUMRDHA.2144TK2MSFTNGP11.phx.gbl... > Hi, > > I want to add simple smtp email messages to my database application. > Basically I have a trigger on a table that when a new record is written to > it an email notification is sent out. > I'm using the AspMail component and using the sp_OACreate sproc. > > It works fine if the user posting to the table has admin rights, otherwise I > get an error. > B/O ...

  1. #1

    Default Re: sp_OACreate permissions in SQL Server 2000.

    Mat,

    Any reasons for not using SQL mail ( master..xp_sendmail ) ?

    --
    Dinesh.
    SQL Server FAQ at
    [url]http://www.tkdinesh.com[/url]

    "Mat" <mat.hornntlworld.com> wrote in message
    news:eK2SbUMRDHA.2144TK2MSFTNGP11.phx.gbl...
    > Hi,
    >
    > I want to add simple smtp email messages to my database application.
    > Basically I have a trigger on a table that when a new record is written to
    > it an email notification is sent out.
    > I'm using the AspMail component and using the sp_OACreate sproc.
    >
    > It works fine if the user posting to the table has admin rights, otherwise
    I
    > get an error.
    > B/O says:
    > Only members of the sysadmin fixed server role can execute sp_OACreate.
    >
    > Is there way round this limitation?
    >
    > Any help would be much appreciated.
    >
    > Mat.
    >
    >

    Dinesh.T.K Guest

  2. #2

    Default Re: sp_OACreate permissions in SQL Server 2000.

    You can create a dbo-owned proc in an sa-owned user database that
    encapsulates your sp_OA* or xp_sendmail calls. If you've enabled
    cross-database chaining (introduced in SQL 2000 SP3) in your user
    database, users only need execute permissions on your user proc.

    Note that cross-database chaining should be enabled only if you fully
    trust members of the db_owner and ddl_admin database roles.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    [url]http://www.sqlserverfaq.com[/url]
    [url]http://www.mssqlserver.com/faq[/url]
    -----------------------

    "Mat" <mat.hornntlworld.com> wrote in message
    news:eK2SbUMRDHA.2144TK2MSFTNGP11.phx.gbl...
    > Hi,
    >
    > I want to add simple smtp email messages to my database application.
    > Basically I have a trigger on a table that when a new record is
    written to
    > it an email notification is sent out.
    > I'm using the AspMail component and using the sp_OACreate sproc.
    >
    > It works fine if the user posting to the table has admin rights,
    otherwise I
    > get an error.
    > B/O says:
    > Only members of the sysadmin fixed server role can execute
    sp_OACreate.
    >
    > Is there way round this limitation?
    >
    > Any help would be much appreciated.
    >
    > Mat.
    >
    >

    Dan Guzman Guest

Similar Threads

  1. Replies: 1
    Last Post: December 23rd, 01:55 PM
  2. Minimal permissions with an Access Database and 2000 server ?
    By Gilles LAMBERT in forum ASP.NET Security
    Replies: 2
    Last Post: October 23rd, 04:42 AM
  3. Replies: 1
    Last Post: September 5th, 08:55 PM
  4. Replies: 0
    Last Post: September 5th, 01:50 PM
  5. User Permissions in SQL Server 2000
    By Anthony Tanzola in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 10th, 03:43 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139