Home > DeveloperSection > Forums > Difference between user created Login and System Admin Created Login?
Pravesh Singh

Total Post:411

Points:2881
Posted on    December-05-2012 12:32 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 1433  View(s)
Rate this:
Hello every one
Please solve my problem! Question is
Difference between user created Login and System Admin Created Login in sqlserver?

Thanks


Vijay Shukla

Total Post:100

Points:700
Posted on    December-06-2012 12:07 AM

 

 

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 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.


Modified On Dec-06-2012 12:12:58 AM

Don't want to miss updates? Please click the below button!

Follow MindStick