Tag: security management

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

• How to GRANT Permissions in T-SQL

  

  2014-01-24 - General, Security

  The T-SQL GRANT statement is a surprisingly complex statement that can be used to control fine grained permissions. In its basic form is has three sections that answer the questions What?, Where? and Who?. Read on to get all the details.

  [more…]

• How to identify the SQL Server Service Account in T-SQL

  

  2014-01-23 - General, Security

  In SP1 for SQL 2008R2 a new DMV was introduced: sys.dm_server_service. It provides information about SQL related services including the service account name. Read on to get all the details.

  [more…]

• The Mystery of the SUSER_NAME() and SUSER_SNAME() functions

  

  2014-01-11 - Fundamentals, General, Security

  The SQL Server functions SUSER_NAME() and SUSER_SNAME() both return the current login name. So why are there two? Read on to find out what the difference is.

  [more…]