Hello every one
Please solve my problem! Question is
Difference between user created Login and System Admin Created Login in sqlserver?
Thanks
Difference between user created Login and System Admin Created Login?
252705-Dec-2012
Updated on 06-Dec-2012
Vijay Shukla
06-Dec-2012Difference 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 any
Database 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.