---
title: "Difference between user created Login and System Admin Created Login?"  
description: "Difference between user created Login and System Admin Created Login?"  
author: "Pravesh Singh"  
published: 2012-12-05  
updated: 2012-12-06  
canonical: https://www.mindstick.com/forum/483/difference-between-user-created-login-and-system-admin-created-login  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Difference between user created Login and System Admin Created Login?

Hello every one \
Please solve my [problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic)! [Question](https://www.mindstick.com/blog/23175/how-to-solve-neet-question-paper-in-less-time) is\
[Difference between user](https://www.mindstick.com/forum/159073/what-is-the-difference-between-user-and-kernel-modes-in-operating-systems) created [Login](https://www.mindstick.com/articles/12852/styles-login-form-in-android) and [System](https://www.mindstick.com/articles/23411/the-most-effective-method-to-find-the-perfect-small-business-phone-system-for-your-business) [Admin](https://www.mindstick.com/articles/12934/3-functionalities-that-a-magento-admin-mobile-app-can-empower-you-with) Created Login in [sqlserver](https://www.mindstick.com/forum/33737/between-condition-in-sqlserver)?\
\
Thanks

## Replies

### Reply by Vijay Shukla

**[Difference](https://www.mindstick.com/articles/157114/good-news-or-bad-news-and-the-difference-is) between [user](https://www.mindstick.com/articles/13001/multi-statement-table-valued-user-defined-function-in-sql-server) 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.


---

Original Source: https://www.mindstick.com/forum/483/difference-between-user-created-login-and-system-admin-created-login

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.
