DIFFERENCE BETWEEN USER CREATED LOGIN AND SYSTEM ADMIN CREATED LOGIN?

Total Post:412

Points:2888
 1944  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. 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 Mar-29-2018 05:46:01 AM

Answer

NEWSLETTER

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