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 ««12

SQL Server Security Part 2 Expand / Collapse
Author
Message
Posted Friday, November 4, 2005 9:09 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 9:53 AM
Points: 3,475, Visits: 584

Hi

The article mentioned denying somethings like syscomments access to PUBLIC. Everyone is a member of Public, will SPs work after that?

Otherwise the article is very good. Chris even did not forget to remind us to take care of cleaning audit tables having in mind the amount of information in them

Yelena




Regards,
Yelena Varshal

Post #235154
Posted Friday, November 4, 2005 10:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, Visits: 33

For those of you new to the article (or others of Chris has posted), he's outstanding.  Check out his other articles.  He also has some excellent e-books on his website on disaster recovery (an issue dear and unfortunately near to my heart).

Keep discussing and debating --it's the only way we truly learn.




Post #235181
Posted Wednesday, November 9, 2005 9:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51
Chris - this is an excellent article. Great work!


Post #236066
Posted Thursday, March 9, 2006 2:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, March 14, 2009 5:17 PM
Points: 85, Visits: 63

yes. dynamic sql in sp works as well. wery easy to test.

Post #264660
Posted Monday, July 23, 2007 12:00 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, February 2, 2013 8:21 AM
Points: 283, Visits: 268
I have a question (and please excuse me if it's been asked before). If I am using SSL between a WebClient and WebServer, is it possible to intercept the communication between the WebServer and SQL Server Database? I would think that the database communication is running on the server end and that the only thing the client can see or intercept would be things that it has a certificate for.

Can someone shed some light on this? Thanks!



Post #384274
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse