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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2006-03-17 : 12:46:14
|
| I have a domain service account that is able to run a stored procedure in the master database WITHOUT an associated login.How is this possible?The stored procedure does show the service account has execute permissions, but sp_helplogins and sp_helpuser don't return any results.Thanks,RaySS2k SE SP4 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-17 : 13:46:24
|
| Is the account in the local admin group? If it is, then does BUILTIN\Administrators have sysadmin server role, which is the default. If so, then that's how it has access.Tara Kizeraka tduggan |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2006-03-17 : 16:49:24
|
| The BUILTIN\Administrators group was removed months ago. The service account is not a member of the local admin group. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-18 : 09:46:14
|
| is it mapped to another login?does the guest account or public role in master has the execute permission on the sp?did you try to query the system tables directly to show the user info?--------------------keeping it simple... |
|
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2006-03-20 : 17:08:37
|
| This is resolved. The service account is a member of the domain development group which has access to the server. In the master database, the service account has a data access type 'Via Group Membership'. |
|
|
|
|
|
|
RESOLVED: database access without login