What are static security profiles and dynamic security profiles, and what are the differences between them?

When it comes to securing data based on factors like location, there are two approaches: static security profiles and dynamic security profiles. Static security profiles involve creating a separate security profile for each location and a data role for each job role within that location. However, this approach can lead to a large number of security profiles and data roles, which can be difficult to maintain and may result in performance issues.

On the other hand, dynamic security profiles offer an alternative solution. With dynamic security profiles, the same data role can be assigned to all HR specialists. They will only see the employees associated with the specific location they are responsible for. This is achieved through a combination of areas of responsibility and custom SQL in the person's security profile.

In the dynamic security profile approach, each HR specialist is assigned an area of responsibility for a specific location. The employees that each HR specialist can view are determined by their area of responsibility assignment, rather than relying solely on the explicit location recorded in the security profile definition.

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.