Security

Row Oriented Security Using Triggers

Handling security in an application can be a bit cumbersome. R Glen Cooper brings us a database design technique from the real world that can help you.

Run an SSIS Package Under a Different Account

In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.

Encryption

Security Regulations

There have been calls for governmental security regulations for IT. Is that a good thing? Steve Jones comments today.

E K M

Database Activity Monitoring Part 2 - SQL Injection Attacks

If you think through the web sites you visit on a daily basis the chances are that you will need to login to verify who you are. In most cases your username would be stored in a relational database along with all the other registered users on that web site. Hopefully your password will be encrypted and not stored in plain text.

Discuss content posted by Gabriel Priester

Discussions about content posted by Gabriel Priester

Using a Parent Child Hierarchy in SQL Server to Implement a Custom Security Scheme

I have a requirement to implement a custom security scheme where roles and the user's place in the organization hierarchy are used to determine which customers a user can access. In particular the requirements are that a sales person can only access their customers and any other role can access any customer in their level of the organization hierarchy and below. We have a simple hierarchy that is made up of regions and offices. Can you provide us with an example of how to do this?

SQL Server Impersonation

SQL Server impersonation, or context switching, is a means to allow the executing user to assume the permissions of a given user or login until the context is set back, set to yet another user, or the session is ended. Deanna Dicken shows you two mechanisms for accomplishing this task and walks through some examples.