Enterprise-grade user provisioning and privilege management for Netezza. Automate the tedious, error-prone parts of access management and integrate with your existing directory services.
The Problem
Netezza's native access control model is capable but low-level. Granting and revoking privileges is done at the SQL level, one statement at a time. There is no concept of role templates, no LDAP sync, and no audit trail unless you build one yourself.
In practice, this means access management becomes a mix of tribal knowledge and manual scripts. Users leave organisations but their accounts stay active. New users get provisioned inconsistently. Compliance audits require someone to manually reconstruct who had access to what and when.
Smart Access Control solves this by sitting above Netezza's native model and adding the automation and governance layer that enterprise environments need.
Common Complaints We Hear
What It Does
Smart Access Control syncs with your organisation's directory service. Users provisioned in AD are automatically reflected in Netezza. Leavers are de-provisioned on schedule. No manual intervention required.
Define role templates that map to business functions: analyst read-only, ETL developer, data steward, DBA. Provisioning a new user becomes a matter of assigning the right template, not running SQL.
Onboard a new team or project group in minutes. Remove access for an entire department in a single operation. All changes are logged with timestamps and operator identity.
Generate a full report of who has access to what, across every schema and table. Schedule monthly or trigger on demand. Output to PDF or CSV for compliance submissions.
Define rules that prevent conflicting privileges from being granted to the same user. For example, a developer cannot hold both ETL write access and production read access simultaneously.
Every privilege change — grant, revoke, role assignment, template application — is recorded with the operator identity, timestamp, and reason. Queryable from SMF Control Studio.
Integration
Smart Access Control connects to your Active Directory or LDAP server and maps directory groups to Netezza role templates. This is a one-time configuration step. After that, user lifecycle management is driven entirely by your HR and IT processes — not by a Netezza DBA running SQL scripts.
Synchronisation runs on a configurable schedule or can be triggered on demand via the SMF Control Studio interface. Conflicts are flagged for review rather than silently resolved.
Ask About LDAP SetupTell us about your current setup. We will assess the gap and design an integration that works with your existing directory service.
Talk to an Engineer