Neoview Database Administrator's Guide (R2.4)

can create and alter roles and user IDs.Any user ID
assigned to the
MGR role...
Thereafter
can create tables in the DB schema.Any user ID
assigned to the
DBA role...
can create tables in the USR schema.Any user ID
assigned to the
USER role...
Creating and Managing Users and Roles With DB Admin
This chapter describes:
• “Understanding Roles and User IDs” (page 22)
• “Creating a New Role” (page 23)
• “Changing the Password and Expiration Date of a Role” (page 24)
• “Deleting a Role” (page 25)
• “Creating a New User ID” (page 26)
• “Changing the Password and Expiration Date of a User” (page 27)
• “Deleting a User ID” (page 28)
• “Viewing User Status” (page 29)
• “Managing Security Policies” (page 30)
Understanding Roles and User IDs
Naming Rules for Roles and User IDs
Table 3-1 Naming Rules for Roles and UserIDs
User IDs
Role Names (ROLE.role_name)
Up to 32 characters in lengthUp to 8 characters in length
Case-sensitiveNot case-sensitive
Alphanumeric and special characters; first character must be
alphabetic
Must be alphanumeric; first character must be
alphabetic
These special characters are allowed: period (.), hyphen (-), and
underscore (_)
No special characters allowed
Using Roles to Perform Tasks
Initially, the database administrator logs on using the ROLE.MGR user ID and a valid password.
After user IDs are assigned, users with valid passwords log on using a user ID that is assigned
to the MGR role.
The database administrator creates a new user ID and assigns a role to the user ID. (If a new role
is required, the administrator first creates the role and then creates the user ID and assigns the
new role.)
Any user who creates a table in the database (and is, therefore, the table owner) grants (or revokes)
access privileges to one or more roles.
Example Scenario
Suppose you are setting up your system. You will need to have some users who can access payroll
information, and others who can access customer information. You create roles for these tasks,
assign access privileges to these roles, then add user IDs assigned to these roles.
22 Managing Roles, User IDs, and Linux Accounts