Oct 1, 2007 #1 isonlyme Programmer Apr 20, 2002 171 PR Hi everyone, Is there a way to create a script that can give you the following? username, what database is using, what role it has, what access have thanks in advanced
Hi everyone, Is there a way to create a script that can give you the following? username, what database is using, what role it has, what access have thanks in advanced
Oct 1, 2007 #2 ptheriault IS-IT--Management Aug 28, 2006 2,699 US Check out this FAQ faq962-5411 - Paul - If at first you don't succeed, find out if the loser gets anything. Upvote 0 Downvote
Check out this FAQ faq962-5411 - Paul - If at first you don't succeed, find out if the loser gets anything.
Oct 1, 2007 Thread starter #3 isonlyme Programmer Apr 20, 2002 171 PR wow thanks perfect, Aditionally is there a way to view the access that a role have? I mean for example: Rolename: RoleSelectOnly Has: Select on TABLENAME1 Select on TABLENAME2 etc. Im a rookie at this sorry and thanks in advanced Upvote 0 Downvote
wow thanks perfect, Aditionally is there a way to view the access that a role have? I mean for example: Rolename: RoleSelectOnly Has: Select on TABLENAME1 Select on TABLENAME2 etc. Im a rookie at this sorry and thanks in advanced
Oct 1, 2007 #4 mrdenny Programmer May 27, 2002 11,595 This thread should have code to view the rights that users and roles have within a database. thread962-1324602 Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com Upvote 0 Downvote
This thread should have code to view the rights that users and roles have within a database. thread962-1324602 Denny MCSA (2003) / MCDBA (SQL 2000) MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration) MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com