Viewing 15 posts - 16 through 30 (of 64 total)
Will give it a try
June 7, 2017 at 6:02 am
When EXECUTE AS CALLER is specified, IMPERSONATE permissions are not required. -- This is why I wonder if you need impersonate access added to the Procedure
June 7, 2017 at 5:54 am
Added to that if I run this
select d.name, d.sid, s.name, s.sid
from sys.database_principals d
full join sys.server_principals s
on d.principal_id = s.principal_id
where d.name = 'SuperUser'
Columns...
June 7, 2017 at 5:51 am
Taken from Microsoft's EXECUTE AS page:
To specify EXECUTE AS on a login, the caller must have IMPERSONATE permission on the specified login name and must not be denied the IMPERSONATE ANY LOGIN permission. To specify EXECUTE...
June 7, 2017 at 5:35 am
Hi John
I am not sure I am following everything, should we be enabling guest access? Guest statuses on all userdatabases are 0
Our DBs have DB Chaining...
June 7, 2017 at 4:44 am
All Databases have the same owner. I have even tried DB_CHAINING. We do use this a bit at clients as well.. As stated before the SuperUser is db_owner(note db_owner role, not...
June 7, 2017 at 2:50 am
What is frustrating is in one environment it is working perfectly, in the others not. We have tried creating a new Super User from scratch(changing the procedure accordingly), this even...
June 7, 2017 at 2:13 am
Sorry about that, was a bit of a rush.
We have a DB(call it DB2) where 3rd parties sign in with views pointing to other databases(call it DB1) through synonyms....
June 7, 2017 at 1:17 am
Thanks, I thought it would be like that. Thanks for the confirmation
October 20, 2016 at 4:13 am
The other option would be to grant them access to modify the job schedule only. Have given them access to the SQL Agent roles in msdb, they can view and...
August 16, 2016 at 5:11 am
Will have a look at it. I saw a lot of BEGIN, ROLLBACK and COMMIT, don't worry those are part of all my standard code, just did not include that.
Will...
July 26, 2016 at 5:25 am
Gail. I would like to get your ideas on error handling in this specific case, not worked much with it
July 26, 2016 at 12:30 am
Thanks to all the guys for their input, Looking at each of them, and I definitely have a lot to work towards, step by step though
June 3, 2016 at 2:19 am
Scoot, thanks, I will investigate what you said
June 1, 2016 at 7:53 am
Viewing 15 posts - 16 through 30 (of 64 total)