Login and its permissions

Question

Login and its permissions

sqlfriend

SSC Guru

Points: 52794
More actions
April 1, 2011 at 11:36 am

#236189

Is there a way or a query that I can find a login that has waht access levels and permissions on all objects on a sql server databases?

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

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

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 1

annasql (4/1/2011)
Is there a way or a query that I can find a login that has waht access levels and permissions on all objects on a sql server databases?

There are lots of script for this :

May be this ones will help u

http://www.sql-server-performance.com/articles/dba/object_permission_scripts_p1.aspx

http://www.mssqltips.com/tip.asp?tip=2142&ctc

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂