Difference between user created Login and System Admin Created Login?

Question

Vijay Shukla · Answer

Difference between user created Login and System Admin Created Login:- System Admin Created Login User Created Login Enforce Password policy is enabled. Enforce Password policy isn’t enabled. Server Roles Public, sysadmin are checked. Only Server Role Public is checked. In this login don’t have Securables Page. In this login have Securables Page. In User Mapping checked 14 databases In this login don’t have anyDatabase is checked. a) DaimondResort b) EXACTMAX c) ExactMAXSUM d) Intranet e) Master f) MindStick g) Model h) MSAuto i) msdb j) NorthwindDb k) tempdb l) TwilioData m) WebCalender n) workbook Note:- Only Public and db_owner are checked in the Database role membership.

forum

Difference between user created Login and System Admin Created Login?

Can you answer this question?

1 Answers