Replies posted by Rafal Zaluski

2 Replies

Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
published in News & Blogs

Cross database scripts on Microsoft AzureBlog

Hi Mark,Yes it’s executed under IAM admin account let’s call it ‘admin_account’ which has all access rights and is listed in  select * from usr_root_admin below code returns ‘ÞÇá€õm9F¢õ-«6¨iRæz­4BŽ4Upãر’ and 0 declare @database_name       nvarchar(2000)declare @command             nvarchar(max)set @database_name = 'IAM'set @command = N'SELECT dbo.tsf_user() AS Tsf_User, dbo.is_authorized_usr_admin(''admin_account'') AS is_authorized_usr_admin'exec dbo.sp_execute_remote @database_name, @command best regardsRafal

4503
Rafal Zaluski
Rookie
3 years ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
published in News & Blogs

Cross database scripts on Microsoft AzureBlog

It's not possible to exec dbo.sp_execute_remote 'IAM', 'insert into dbo.usr (....' to add new user as an automated task.IAM function 'is_authorized_usr_admin' is blocking sp_execute_remote to execute on IAM

4503
Rafal Zaluski
Rookie
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings