Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

usp_SecurCreation - SQL 2k Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2008 7:02 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 2012 9:04 AM
Points: 84, Visits: 144
Comments posted to this topic are about the item usp_SecurCreation - SQL 2k
Post #504428
Posted Friday, June 27, 2008 6:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 1:19 PM
Points: 318, Visits: 1,127
Nice script. Is there plans to cover it to SQL 2005?


Post #524929
Posted Friday, June 27, 2008 4:02 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 2012 9:04 AM
Points: 84, Visits: 144
Already covered! :D

usp_SecurCreation - 2k5
Post #525375
Posted Monday, June 30, 2008 6:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 1:19 PM
Points: 318, Visits: 1,127
Thanks 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,

Rudy



Post #525857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse