- Satisfy the Prerequisites.
- Assign users to functional groups to help assess user setup needs. See Database User Functional Categories.
- Use profiles to set user parameters, such as space allocations, password control settings, and security constraint assignments. See Working with Database Profiles.
- Review the database user types shown in Database User Types and determine which of them apply to your authentication and authorization strategy. The method for creating users and defining their database privileges varies by user type.
- Create the required users:
- Review Teradata Vantage User Privileges to understand which privileges you must grant and which are acquired indirectly.
- Assign user privileges:
- Directly to permanent database users. See Granting Privileges to Permanent Database Users.
- To roles, for permanent database users. See the topics beginning with Using Roles to Manage Privileges.
- To roles, for proxy users. See Working with Roles for Proxy Users.
- To external roles, for directory users. See Using Roles for Directory Users.When creating users and assigning user privileges, any SQL statements routed through Unity apply to all connected Vantage systems.
- Review additional methods for restricting access based on the structure of the database and its component parts. See Other Options for Restricting Database Access.