SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups | SqlServerZest.com

Earlier today I was required to pull the list of all SQL Login Accounts, Windows Login Accounts and Windows Group Login Accounts (basically all the Logins along with the Account Type of the Login) …

Источник: SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups | SqlServerZest.com

 

Раньше или позже у любого DBA возникает животрепещущий вопрос- кто именно из пользователей заведен на сервере и что он там может делать? Мир не без добрых людей, кое-что посоветовали (хотя для работы придется докрутить)

 

SELECT name AS Login_Name, type_desc AS Account_Type
FROM sys.server_principals 
WHERE TYPE IN ('U', 'S', 'G')
and name not like '%##%'
ORDER BY name, type_desc

 

SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups | SqlServerZest.com: 14 комментариев

  1. frederickachen

    Hello there, I found your site by means of Google while looking for a related subject, your website came up, it seems great. I’ve bookmarked it in my google bookmarks.
    Hi there, simply was aware of your blog via Google, and found that it’s truly informative. I am going to be careful for brussels. I’ll be grateful in the event you continue this in future. A lot of folks might be benefited from your writing. Cheers!

  2. irvinneill6366

    I have been browsing online greater than three hours lately, but I never discovered any attention-grabbing article like yours. It’s lovely value enough for me. In my opinion, if all web owners and bloggers made good content as you did, the web shall be much more useful than ever before.

  3. arlenemarden9

    I am now not positive the place you are getting your info, but great topic. I needs to spend a while learning much more or understanding more. Thanks for great info I used to be in search of this info for my mission.

  4. irvinneill6366

    When someone writes an piece of writing he/she maintains the image of a user in his/her brain that how a user can know it. So that’s why this paragraph is outstdanding. Thanks!

  5. irvinneill6366

    Great blog here! Also your website lots up very fast! What host are you using? Can I get your affiliate link to your host? I desire my website loaded up as fast as yours lol

  6. irvinneill6366

    Thanks for one’s marvelous posting! I truly enjoyed reading it, you will be a great author. I will make certain to bookmark your blog and will eventually come back in the future. I want to encourage yourself to continue your great job, have a nice evening!

  7. irvinneill6366

    Its such as you read my mind! You seem to understand so much approximately this, such as you wrote the e-book in it or something. I feel that you could do with a few percent to force the message house a little bit, however instead of that, that is wonderful blog. An excellent read. I will certainly be back.

Добавить комментарий для arlenemarden9 Отменить ответ

Ваш адрес email не будет опубликован. Обязательные поля помечены *