Tag: SQL Server

• Is Granting on All Columns Really the Same as Granting on the Table Itself?

  

  2014-01-30 - General, Security, Security Misconceptions

  Permissions on a table level and permissions granted to all columns on that table appear identical at first. However there actually is a big difference. Read on to find out all about it.

  [more…]

• GRANT … AS: Using GRANT … WITH GRANT OPTION for Roles

  

  2014-01-26 - General, Security

  Permission delegation does not work with database and server roles as you would expect. Instead of an automatic permission cascade, every role member needs to take additional actions to delegate successfully. Read on to get all the details.

  [more…]

• WITH GRANT OPTION: How to Delegate your Permission Management

  

  2014-01-25 - General, Security

  Granting a permission to a user normally does not enable that user to pass the permission on. However the WITH GRANT OPTION extension to the GRANT statement enables just that. Read on to get all the details.

  [more…]

• ORIGINAL_LOGIN() – How to identify the Original Login Name

  

  2014-01-22 - General, Security

  ORIGINAL_LOGIN() is a SQL Server function that returns the original login name that was used to make the connection to the instance. Read on to get all the details.

  [more…]

• Log Reuse Waits Explained: LOG_SCAN

  

  2014-01-21 - General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting LOG_SCAN as reason? Read on to find out what that means and what you can do about it.

  [more…]