-
Interesting findings on schema owner permissions
I found out recently that a schema owner does not necessarily have right to create objects for its own schema, but can drop and grant permissions for its objects, which is kind of strange. Try this: 1. Create 2 logins: USE [master] GO CREATE LOGIN [Login1] WITH PASSWORD=N’xxx’, DEFAULT_DATABASE=[AdventureWorks], CHECK_EXPIRATION=ON, CHECK_POLICY=ON CREATE LOGIN [Login2] WITH…
-
C2 and Common Criteria Compliance
In Sql Server 2000, C2 auditing is a US government standard that monitors database security. When it is enabled, a trace will be created to collect all Security Audit related events, 21 or so of them. You can find what those events are by browsing through them in Profiler. By default, the trace file will…
-
Frankie’s Deli
Frankie’s Deli is a quick deli store in Yorktown Center, Lombard, Illinois. It is close to my current work location. In my opinion, this deli store makes the best sandwiches at unbeatable prices. All ingredients are top quality. My favorites are: 1. Frankie’s special, with imported capicola, marinated eggplant, and optional provolone cheese. You get…
-
Seeking mobile communication advice
I am going through some changes, dear reader: I have decided to quit my corporate day job and start my own consulting/training business, starting on April 9th, 2007. I could use your help here: I’d appreciate it greatly if you could offer me leads on Sql Server, Oracle, and MySQL consulting and training gigs. I…
-
A few handy Sql Server tips
Here are a few handy tips I learned lately: 1. When using sp_configure, you don’t need to type the whole parameter string. You just need to type enough of it for Sql Server to be uniquely identify it. For example, sp_configure ‘show ad’ will resolve to sp_configure ‘show advanced’ 2. In Query Analyzer or Management…