SQL Server query to find all permissions/access for all users in a database

10/14 16:00
阅读数 0

问题:

I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to roles, etc. This report would be used for security auditing purposes.我想在 sql 2008 上编写一个查询,该查询将直接或由于角色等原因报告有权访问特定数据库或数据库中的对象(例如表、视图和存储过程)的所有用户。这报告将用于安全审计目的。 Not sure if anyone has a query that will fit my needs completely, but hopefully something that will give me a good start.不确定是否有人有完全符合我需求的查询,但希望能给我一个良好的开端。 Either sql 2008, 2005 or 2000 will do, I can probably convert as needed. sql 2008、2005 或 2000 都可以,我可能可以根据需要进行转换。


解决方案:

参考一: https://en.stackoom.com/question/TZix
参考二: https://stackoom.com/question/TZix
展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部