Hi folks,
Is there any easy way of finding out, using a query, all permissions that a user has on any securable? Also, what sort of permission (e.g. ALTER, SELECT, INSERT etc..)
I'm going to hunt around on Google but thought I'd post here in case anyone can tell me before I find it.
thanks in advance.
-Jamie
ignore this.
select *
from sys.database_permissions
does me right!
Doh!
-Jamie
