sysadmin fixed server role??? 2

[rsshetty]

Does anyone understand what the following statement means?

If your SQL Server user is not a member of the sysadmin fixed server role, you cannot use the stored procedure that is mentioned in the example to send e-mail.

With reference to:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech

Under the heading:
Create a Stored Procedure to Send CDONTS E-Mail

rsshetty.
It's always in the details.

 

[Catadmin]

SysAdmin role is the pinnacle of fixed server roles. It has all permissions and certain system stored procedures and database operations require it in order to execute said task.

Verify what server roles and user permissions your SQL account has. If your user account doesn't have Execute permission on that stored procedure (Go to Security, Logins, Rightclick Users to see object permissions in Enterprise Manager), then you'll need to log in as a SysAdmin account like SA or the local system account to run it. If you have the Security Admin role, you can grant yourself permissions on the SP. If you have Setup Administrators, you can run the extended (and I presume the regular) stored procedures.

See Fixed Server Roles in Books Online for more detail.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[JohnDTampaBay]

Only members of the sysadmin fixed server role can run the OLE Automation [sp_OA] stored procedures. Because the procedure described using sp_OA procedures to manipulate OLE objects in order to send emails, only sysadmin personnel would be able to utilize it.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Catadmin]

Oh, thanks for the correction, John. I didn't catch that this was in reference to a specific stored procedure.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[rsshetty]

Well the place where I work has not granted me SysAdmin role. Before I ask for it, is there any specific reason NOT to grant SysAdmin role? I run the SQL client on my machine.

rsshetty.
It's always in the details.

 

[Catadmin]

There's plenty of reason. It has to do with who has the ability to control the data and the database. Or in the office venacular "Keeping out the hackers and bugs".

Are you the main SQL Server DBA? If so, then there should be one account with SysAdmin on it, but not your regular User Acct (to prevent hackers from getting into your system and using your permissions against the company).

If not, then I would discuss the issue with your main DBA, but don't be too surprised if, after rational discussion, they still decide not to give it to you.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[rsshetty]

Thanks. I guessed as much.

rsshetty.
It's always in the details.