Netezza Performance Server security and access control

This section describes how to manage the database user accounts, and how to apply administrative and object permissions that allow users access to databases and capabilities. This section also describes user session controls such as row limits and priority that help to control database user impacts on system performance.

You can control access to the Netezza Performance Server system itself by placing the system in a secured location such as a data center. You can control access through the network to your Netezza Performance Server system by managing the Linux® user accounts that can log in to the operating system. You control access to the Netezza Performance Server database, objects, and tasks on the system by managing the Netezza Performance Server database user accounts that can establish SQL connections to the system.

Note: Linux users can log in to the Netezza Performance Server system at the operating system level, but they cannot access the Netezza Performance Server database by SQL. If some of your users require Linux accounts to manage the Netezza Performance Server system and database accounts for SQL access, you can use identical names and passwords for the two accounts to ease management. Throughout this section, any references to users and groups imply Netezza Performance Server database user accounts, unless otherwise specified.