Last week I wanted to see what rights users have on my Azure databases. When you open SSMS and check out the options, you’ll soon realise there are things missing. One of them is the user properties.
Where are the properties?
Now i needed the properties of not just one, but of all my users. At almost the same time a blog hit my inbox by Kenneth Fissher (b | t). He wrote an excellent procedure that will list all your users and their rights. You can find the blogpost referring to that procedure here. Thank you Kenneth! If you find his procedure usesfull, let him know!
Reitse began his computer days with GW Basic and quickly followed with Windows 3.11. After that many computers followed and, interrupted by human resource and psychology studies, he got into the IT work field around 2007. There he met Oracle 9. With a command line from 1980. At his current job he met SQL Server. And loved it. Now he’s working with SQL 2008 to SQL 2019 on-premises and a number of Azure SQL Databases, supporting customers and tuning databases. New projects focus more on the Azure data platform as an architect, security advisor and data engineer.
View all posts by reitsees
Reitse's blog 