Tag: Permission

• 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 Principle of Least Privilege

  

  2014-01-01 - General, Security

  The Principle of Least Privilege tells us to always grant only the minimal set of permissions to any user. Read on to see what this means in the context of SQL Server.

  [more…]