ASA Database Administration Guide
Managing User IDs and Permissions
This section describes how to create new users and grant permissions to them. For most databases, the bulk of permission management should be carried out using groups, rather than by assigning permissions to individual users one at a time. However, as a group is simply a user ID with special properties, read and understand this section before moving on to the discussion of managing groups.
Creating new users
Changing a password
Granting DBA and RESOURCE authority
Granting permissions on tables
Granting permissions on views
Granting users the right to grant permissions
Granting permissions on procedures
Execution permissions of triggers
Granting and revoking remote permissions
Revoking user permissions
Deleting users from the database