user_img
Asked by: Cyril Carota
Questioner General

how to find who created login in sql server

Link of how to find who created login in sql server page is given below. Pages related to how to find who created login in sql server are also listed.

Last Updated: Wed Jul 31 2019

13
how to find who created login in sql server
website screenshot
default

Added by: Samuel Piacenza

Explainer

I want to find out in SQL SERVER 2012, who is creating SQL ...

SQL server wont generally keep a track of this. So you have to make use of the default trace to gather the information for EventClass 109. Make sure to check that default trace is running using: SELECT* FROM sys.configurations WHERE configuration_id = 1568
Url: https://dba.stackexchange.com/questions/131261/i-want-to-find-out-in-sql-server-2012-who-is-creating-sql-logins-and-on-which-d

35780

Monthly Visits

3199302

Alexa Rank

flag US

Popular in

Up

Service Staus

23h ago

Last Checked

website screenshot
default

Added by: Ralph Kuhs

Explainer

Manage-SQLServer: Who created the login in SQL Server

How can we find out who has created a particular login in SQL Server We can get the information by the default trace files in the SQL Server. There will be only 5 trace files available so if we want to troubleshoot we have to be quick here, the more we delay archiving of trace files may happen and we will loose the data to troubleshoot
Url: https://manage-sqlserver.blogspot.com/2012/08/who-created-login-in-sql-server.html

24133

Monthly Visits

1629862

Alexa Rank

flag US

Popular in

Up

Service Staus

6h ago

Last Checked

website screenshot
default

Added by: Mary Hawn

Explainer

How to find who created a sql server 2005 login?

select * from sys.syslogins--- Gives the time of creation but not who created the login. SELECT * FROM fn_trace_gettable ('C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\log.trc', default) GO-- Doesn't give the 'create login' t-sql even if I create & drop a test login in the TextData Column.
Url: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/efe5bf1c-ec53-4ed9-b568-eb43b650f29c/how-to-find-who-created-a-sql-server-2005-login

26136

Monthly Visits

2987601

Alexa Rank

flag US

Popular in

Up

Service Staus

7h ago

Last Checked

website screenshot
default

Added by: Lyndon Rubinow

Explainer

Who created a server login in SQL Server? Power of Default ...

Lets discuss this in a better and interesting way : Business Manager - Login 'guyxyz' is causing lot of issues and we need to know who created this login without our knowledge?. DBA : Hmm! I need some time to gather this info as this is not logged anywhere as per my understanding,and I would like to do an R&D to confirm that.
Url: https://sqlsailor.com/2011/03/29/who-created-a-server-login-in-sql-server/

34216

Monthly Visits

1429672

Alexa Rank

flag US

Popular in

Up

Service Staus

4h ago

Last Checked

website screenshot
default

Added by: Raeann Sebastiano

Explainer

Finding Login Counts and Creation Dates | IT Pro

SELECT name, createdate FROM master..syslogins GO Similarly, you can execute the following queries in a database to find the count of users for that database, a list of the user names, and the dates the users were created: USE GO SELECT COUNT (*) FROM sysusers SELECT name, createdate FROM sysusers GO
Url: https://www.itprotoday.com/finding-login-counts-and-creation-dates

19137

Monthly Visits

2284710

Alexa Rank

flag US

Popular in

Up

Service Staus

12h ago

Last Checked

website screenshot
default

Added by: Dusty Canalez

Explainer

SQL Server: Find Logins in SQL Server

SQL Server: Find Logins in SQL Server Question: Is there a query to run in SQL Server that will return all SQL Server Logins and information about those Logins? Answer: In SQL Server, there is a catalog view (ie: system view) called sys.sql_logins.You can run a query against this system view that returns all of the Logins that have been created in SQL Server as well as information about these ...
Url: https://www.techonthenet.com/sql_server/questions/find_logins.php

17935

Monthly Visits

1491514

Alexa Rank

flag US

Popular in

Up

Service Staus

8h ago

Last Checked

website screenshot
default

Added by: Von Ciullo

Explainer

Find create date for user login - SQLServerCentral

figuring out when the user was deleted will be a hard job. Regarding when a user has been added to a database: maybe this query can help out. use yourdb
Url: https://www.sqlservercentral.com/forums/topic/find-create-date-for-user-login

44192

Monthly Visits

1785709

Alexa Rank

flag US

Popular in

Up

Service Staus

22h ago

Last Checked

website screenshot
default

Added by: Kanisha Freibert

Explainer

How to check who created a sql database inside my server

PS. we are using shared user id to log in to the sql server. So only way is to find out IP address or something. The best you will get is when it was created. In SSMS, right-click the SQL Server instance, select Reports > Standard Reports > Schema Changes Report.
Url: https://community.spiceworks.com/topic/2218421-how-to-check-who-created-a-sql-database-inside-my-server

38560

Monthly Visits

610358

Alexa Rank

flag US

Popular in

Up

Service Staus

1h ago

Last Checked

website screenshot
default

Added by: Chante Hinnant

Explainer

SQL Server Logins, Users and Security Identifiers (SIDs)

When the login u007 is granted access to a database in SQL Server, it creates a database user which maps back to the instance level login. Internally in SQL Server, the Windows login maps back to the database user using the same SID value. So, the database user name can pretty much be any name and the permission would still work fine.
Url: https://www.sqlshack.com/sql-server-logins-users-security-identifiers-sids/

30009

Monthly Visits

4538012

Alexa Rank

flag US

Popular in

Up

Service Staus

11h ago

Last Checked

website screenshot
default

Added by: Gale Robare

Explainer

List logins on SQL Server instance - SQL Server Data ...

User grants a login access to the database List users in SQL Server database. One login can be associated with many users but only in different databases. Query select sp.name as login, sp.type_desc as login_type, sl.password_hash, sp.create_date, sp.modify_date, case when sp.is_disabled = 1 then 'Disabled' else 'Enabled' end as status from sys ...
Url: https://dataedo.com/kb/query/sql-server/list-logins-on-server

41648

Monthly Visits

4777905

Alexa Rank

flag US

Popular in

Up

Service Staus

6h ago

Last Checked

bookmark icon

Bookmark Our Site

attention

Press Ctrl + D to add this site to your favorites!

stamp

Co-Authored By:

GoLogins Staff Editor

1

Wed Jul 31 2019

10948

49

Active

29

Answers

1

Images

44

Users

92% of readers found this page helpful.

4.6/5

Click a star to add your vote