question

sag avatar image
sag asked

1) I want query to Identify and report on any logins within Production databases that include "test" , "QA" , "UAT".

I want query to Identify and report on any logins within Production databases that include "test" , "QA" , "UAT".

sql server
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Not much to go on there I'm afraid.

Do you want a list of users inside the PROD database which contain the phrase TEST, QA, UAT?

SELECT name FROM sys.database_principals where name like '%test%' or name like '%QA%' or name like '%UAT%'

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.