usp_SecurCreation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Pedro Lopes » usp_SecurCreation - SQL 2k

usp_SecurCreation - SQL 2k

Rate Topic

Display Mode

Topic Options

Author

Message

Pedro Lopes MS

Posted Wednesday, May 21, 2008 7:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 07, 2012 9:04 AM
Points: 84, Visits: 144

Comments posted to this topic are about the item usp_SecurCreation - SQL 2k

Post #504428

Rudy Panigas

Posted Friday, June 27, 2008 6:44 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:35 AM
Points: 306, Visits: 1,020

Nice script. Is there plans to cover it to SQL 2005?

Post #524929

Pedro Lopes MS

Posted Friday, June 27, 2008 4:02 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 07, 2012 9:04 AM
Points: 84, Visits: 144

Already covered! :D

usp_SecurCreation - 2k5

Post #525375

Rudy Panigas

Posted Monday, June 30, 2008 6:40 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:35 AM
Points: 306, Visits: 1,020

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 »

Permissions