Creating a login profile

The following steps describe creating a login profile and login account for a particular server and manage permissions for the users.

1. A system security officer creates a login profile for login accounts.

2. A system security officer creates a login account for a new user and associates the login profile to the new login account.

3. A system administrator or database owner adds a user to database or assigns a user to a group.

4. A system security officer grants specific roles to the user or to a login profile.

5. A system administrator, database owner, or object owner grants the user or group specific permissions on specific commands and database objects.

This example creates a login profile mgr_lp:

create login profile mgr_lp

See create login profile in the Reference Manual: Commands.