Tag: SQL Server

• Member Management for Server Roles

  

  2014-01-05 - General, Security

  Server Roles allow for simplified security management for server level permissions in SQL Server. Learn how to add new members, remove existing ones or list all current members of a server role. [more…]

• Using Server Roles for Server Level Security Management

  

  2014-01-04 - General, Security

  Server roles simplify management of server level permissions. Before SQL Server 2012 we were confined to 9 fixed server roles. However, now we are able to create user-defined server roles and grant any server level permission to them. Read on to find out more…

  [more…]

• SQL Server Database Users and the sys.database_principals catalog view

  

  2014-01-03 - DMVs & CVs, General, Security, Security

  Database principals like the database user allow use to grant permissions on objects in a given database. Check out how to list users and find their linked logins.

  [more…]

• SQL Server Logins and the sys.server_principals catalog view

  

  2014-01-02 - DMVs & CVs, Fundamentals, General, Security, Security

  SQL Server knows two types of security principals: The login or server principal and the database user or database principal. Read on to learn more about the server principal.

  [more…]

• The TRUSTWORTHY Database Property Explained – Part 3

  

  2013-06-25 - General, Security, Trustworthy

  Even if you follow security best practices to minimize the risk when setting a database to TRUSTWORTHY, if you use it to allow assemblies external access you are opening up another security hole. Read on to learn more.

  [more…]