DIFFERENCE BETWEEN USER CREATED LOGIN AND SYSTEM ADMIN CREATED LOGIN?

Pravesh Singh

Total Post:412

Points:2888
Posted by  Pravesh Singh
 1745  View(s)
Ratings:
Rate this:
Hello every one
Please solve my problem! Question is
Difference between user created Login and System Admin Created Login in sqlserver?

Thanks
  1. Vijay Shukla

    Post:100

    Points:700
    Re: Difference between user created Login and System Admin Created Login?

     

     

    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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!