RE: Permissions required to select from sys.services?

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Tue, 25 Sep 2007 21:09:35 +0000 (UTC)

Caribou (Caribou@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:

Okay, we've found a solution to this issue. In our system, the code I
pasted below is encapsulated in a stored procedure. We've changed our
stored procedure to run under the security context of OWNER using
Execute As Owner.

This may be OK or not be OK. Personally, I think EXECUTE AS has implications
that are quite nasty. My preference is to use certificate signing. A little
more hassle, but less issues.

For a longer discussion on both certificates and EXECUTE AS, see this
article on my web site: http://www.sommarskog.se/grantperm.html.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Prev by Date: Re: Extracting logins from a master database
Next by Date: Re: Impossible to use a view of a table from another database
Previous by thread: Encryption on sql server 2008
Next by thread: Re: Impossible to use a view of a table from another database
Index(es):
- Date
- Thread

Relevant Pages

RE: exec sp_help_job user account rights
... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
(microsoft.public.sqlserver.security)
Re: Problem with the Legacy ASP files and the Sql Server Express
... It looks like it is not going to be an easy job getting it to work on the SQL Server 2005 and Express:(. ... 'Then you can execute the command and then retrieve the ID ... I am 100% sure this code works against any version of SQL Server, as long as the connection is OK and the SP has two parameters @varCompany as Input and @Return_Value as Output. ... I do not think your problem is due to difference of SQL Server2000 and SQL Server2005, unless your stored procedure has some thing that only works in SQL Server2000, not SQL Server 2005. ...
(microsoft.public.dotnet.framework.aspnet)
RE: exec sp_help_job user account rights
... I don’t know whether it work or not, but u can create a stored procedure ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
(microsoft.public.sqlserver.security)
Re: Stored Procedure Security/Permissions
... Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 ... > permission to read either table; ... > permission to execute the stored procedure, ...
(microsoft.public.sqlserver.security)
Connection.Execute and SQL stored procedures
... ..asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ...
(microsoft.public.sqlserver.odbc)