[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

finding out who created a db object

How can I find out who created a database object? Is the default trace the only way?
0
david_32
Asked:
david_32
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Do you mean the Login through which the object is created?

If that is the case, then default trace is the only way to identify it.
Because a login can create views in many schema or database..
0
 
david_32Author Commented:
thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now