Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2010-03-12 : 15:23:41
|
| Hi,Is it possible to execute xp_fileexist with a SQL login without granting sys admin access to the SQL login?With execute access on xp_fileexist it doesn’t return the correct result.Thank youAK |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-03-12 : 17:52:37
|
| Per Microsoft:"If the calling user is ‘sa’ this Stored Procedure is executed in the context ofthe SQL Server system account. In all other cases the Stored Procedure willbe executed in the context of the calling user (i.e. the Stored Procedure willimpersonate the user). This impersonation will fail for the case that a SQLlogin is used and an empty set will be returned."So it sounds like you can have a non-sysadmin use the procedure but only if they are using integrated security.=======================================There are no passengers on spaceship earth. We are all crew. -Marshall McLuhan, educator and philosopher (1911-1980) |
 |
|
|
|
|
|
xp_fileexist - permission