Breaking News
Loading...
28/08/2013

Login cannot be assigned to a user without login

Given the following code:
USE tempdb;
go
CREATE LOGIN SSC_Question 
  WITH PASSWORD = 'SSC', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;

CREATE USER SSC WITHOUT LOGIN;

ALTER USER SSC WITH LOGIN=SSC_Question

DROP USER SSC

DROP LOGIN SSC_Question
Will the alter user statement succeed?
Choose your answer:


Correct answer: 

No, login cannot be assigned to a user without login

Explanation: 

The WITH LOGIN clause enables the remapping of a user to a different login. Users without a login, users mapped to a certificate, or users mapped to an asymmetric key cannot be re-mapped with this clause.

0 comments:

Post a Comment

 
Toggle Footer