user permission

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

padhis SSCommitted Points: 1762 More actions · Answer 1

Use this.

EXECUTE AS USER = 'Wanida'; -- User name

SELECT * FROM fn_my_permissions('HumanResources.Employee', 'OBJECT')

ORDER BY subentity_name, permission_name ;

REVERT;

GO

more details.

vikingDBA SSCertifiable Points: 5356 More actions · Answer 2

Here is the url to a script I wrote to do a full instance security audit. It gives all permissions for each database.

Maybe it will help.