Re: Permission to view system tables in master database
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 27 May 2007 21:35:12 +0000 (UTC)
Dave (Dave@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I am trying to avoid the "Permission denied" error message when a proc
tries to select records from one of the system tables in a SQL Server
2005 master database.
Sepcifically I need to be able to capture the IP address of the calling
user which I can get from sys.dm_exec_connections.
I have struggled with this for some time and could not find anything
directly on point in MSDN. However, I was able to cobble something
together that "appears" to work as shown below.
I am hoping that someone who has specific experience with this issue
might be able to comment on my approach and point out any issues or
deficiencies.
Yes, you have to do something you did, although you don't the EXECUTE
AS thing. Certificate signing is all you need. I have an article on
my web site that show how you can do this:
http://www.sommarskog.se/grantperm.html
Since you seem to have grasped some of this already, you may want to
rush through until the first BULK INSERT example.
--
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
.
- References:
- Prev by Date: RE: Permission to view system tables in master database
- Next by Date: Re: No access at sql 2000 DB after restore on an other sql server
- Previous by thread: RE: Permission to view system tables in master database
- Next by thread: Re: Permission to view system tables in master database
- Index(es):
Relevant Pages
|
