impersonation - Problem with SQL Server "EXECUTE AS" -


I got the following setup:

There is a SQL Server DB with several tables on them The set trigger (which collects history data) is the stored procedure 'history wizard' for these triggers CLR processed with . HistoryUser User is a simple user in the database without logging in. There are enough permissions to read and write in the History table from all tables.

When I back up the DB and then restore it to another machine (in this case the virtual machine, but it does not matter), the trigger does not work anymore. In fact, the user No impersonation works for now. The user = 'HistoryUser'

generates an error even as a simple statement such as 

  exec ('select 3') :  
 
 The database can not be executed as a principal because the principal "HistoryUser" does not exist, this type of principal can not be impersonated, or you do not have permission.   
 If the DB owner is a domain user, then it may be, but it is not. And even if I change it to something else (their recommended solution) this problem remains.  
 If I make another user without a login, then I can use it for impersonation. This is, it works just fine:  
  Create a User TestUser without user login, exec (select 3 ') as the user =' TestUser ' 
 
 I do not want to repeat those triggers again, so is there any way that I can work current  HistoryUser ? 
 
  Bump:  Sorry, but this is a little necessary ...

Find the orphaned user, then solve it by linking to a login.

Detect:

USE & lt; Database_name & gt;
GO;
sp_change_users_login@action = 'report';
Go;

Resolve:
In the command given below, & lt; Login_name & gt; & Lt; Database_user & gt; With the database user specified by: USE & lt; Database_name & gt;
Live
sp_change_users_login @ action = 'update_one',
@ UserNamePattern = '& lt; Database_user & gt; ',
@ Login Name =' & lt; Login_name & gt; ';
Go


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more