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 |
|
drexasaurus
Starting Member
1 Post |
 Posted - 2012-04-10 : 18:34:20
|
| I created a login with an obtuse password to be able to execute stored procedures that need to execute this stored procedure. According to Microsoft, this user to execute this procedure needs to be a member of the fixed role "sysadmin", so I planned to execute this procedure as this login (to be used for no other purpose).It doesn't work if I just give him the role however. It does work, however, if I give it the "db_owner" role of the master database. I don't understand what's happening, and I don't like to implement things what I don't understand what's happening. Is this something to do with the fact that the procedure is being called from another database?Thank you for your help in advance. |
|
|
|
|
|
sp_OACreate and permissions