-2

I am a new DBA and am trying to do some documentation on the SQL estate that I am responsible for. Currently I have no documentation on anything so this is all from scratch. I am hoping to find out if there is a way I can map every SQL server login to the data that it has access to (database, table, etc). Is this possible?

0

You might also want to look into the dbatools. Get-DbaPermission can retrieve a list of permissions for you:

https://docs.dbatools.io/#Get-DbaPermission

This thread might also come in handy.

  • Please consider reading the following article: How do I write a good answer? (Help Centre) In the section Answer the question there is a short sentence which reads: Links to external resources are encouraged, but please add context around the link so your fellow users will have some idea what it is and why it’s there – hot2use Feb 14 at 14:09
0

As dbatools is a great one already mentioned in answer you might also want to check this ps script Documenting SQl server access , who can do what?

In addition I personally use and is my favorite is db permission sp here

There are many third party tools like idera which I can recall for now works charms.

  • Please consider reading the following article: How do I write a good answer? (Help Centre) In the section Answer the question there is a short sentence which reads: Links to external resources are encouraged, but please add context around the link so your fellow users will have some idea what it is and why it’s there – hot2use Feb 14 at 14:09
0

If anyone is interested, the link below has the script that I found to be very useful. https://it.toolbox.com/question/script-to-list-all-sql-server-database-users-and-their-access-rights-into-a-flat-file-072811

  • Please consider reading the following article: How do I write a good answer? (Help Centre) In the section Answer the question there is a short sentence which reads: Links to external resources are encouraged, but please add context around the link so your fellow users will have some idea what it is and why it’s there – hot2use Feb 14 at 14:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.