SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Pedro Lopes / usp_SecurCreation - SQL 2k / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:06:42 GMT20RE: usp_SecurCreation - SQL 2khttp://www.sqlservercentral.com/Forums/Topic504428-896-1.aspxThanks for the info. But I seem to have problems with the results. To test this stored proc, I have created a user and given it specific rights to several databases. Now when I execute the code all I get is the grant user to login. None of the database rights appear.Is this correct?Thanks,RudyMon, 30 Jun 2008 06:40:01 GMTRudy PanigasRE: usp_SecurCreation - SQL 2khttp://www.sqlservercentral.com/Forums/Topic504428-896-1.aspxAlready covered! :D[url=http://www.sqlservercentral.com/scripts/Administration/63173/]usp_SecurCreation - 2k5[/url]Fri, 27 Jun 2008 16:02:44 GMTPedro Lopes MSRE: usp_SecurCreation - SQL 2khttp://www.sqlservercentral.com/Forums/Topic504428-896-1.aspxNice script. Is there plans to cover it to SQL 2005?Fri, 27 Jun 2008 06:44:36 GMTRudy Panigasusp_SecurCreation - SQL 2khttp://www.sqlservercentral.com/Forums/Topic504428-896-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Administration/63172/">usp_SecurCreation - SQL 2k</A>[/B]Wed, 21 May 2008 07:02:29 GMTPedro Lopes MS