November 14, 2008 at 10:02 am
I am trying to generate a report for all logins/users server/database level permissions (roles), please share if you have any ideas.
November 14, 2008 at 10:47 am
did you check sp_helprolemember ?
btw with sql2005 you can use:
select *
from sys.database_permissions
where class_desc = 'schema'
and grantee_principal_id = DATABASE_PRINCIPAL_ID ('Urole_Appl')
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 14, 2008 at 11:21 am
This script might suit your needs. It only works in SQL 2000.
Greg
November 14, 2008 at 12:00 pm
Greg,
It works but not showing server level permissions.
November 15, 2008 at 10:28 am
Sorry, that's all I have at the moment. I know sp_helpsrvrrolemember will give you server role membership info.
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply