Hackers Beware: Keep Bad Guys at Bay with the Advanced Security Features in SQ... - The Diigo Meta page

• 18 Jan 07
  

  Nilas Jensen

  security sql_server sql_server_2005

  • Figure 5
  • Certificates are essentially wrappers for a public key
  • Detaching a database with an existing master key and moving it to another server can cause a problem, since the new server's Service Master Key will be different. ALTER MASTER KEY has options to drop encryption by the Service Master Key on the old server and then add it back on the new server. Otherwise, the master key will always have to be explicitly opened before use.
  • activating an application role suspends other permissions for the duration that the role is active
  • SELECT * FROM sys.fn_builtin_permissions(default)

  3 more annotations...

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.