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