Tag: misconception

• 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…]

• ALL PRIVILEGES – The Misleading Permissions Shortcut

  

  2014-01-28 - General, Security, Security Misconceptions

  GRANT ALL PRIVILEGES suggest it will grant all applicable privileges on a securable to a principal. However, in most RDBMSs including SQL Server this is not actually the case. In addition, this feature has been deprecated. Read on to get all the details.

  [more…]