New user creation

All new users are automatically added to the PUBLIC group.

A user with DBA authority can set the permissions granted automatically to new users by assigning permissions to the special PUBLIC user group. See Special groups and users.

By default, the permissions assigned to new users include:

The ability to connect to the database (assuming a password has been specified for the user).
The ability to view the data stored in the system views. (To access tables in the database, new users need to be assigned permissions.)
The ability to execute most system stored procedures.

Once you have created a new user, you can:

Add the user to other groups. See Granting group membership to an existing user or group.
Set the user's permissions on tables, views, procedures, sequence generators, and dbspaces. See Users.
Assign a login policy to the user. By default, a user is assigned to the root login policy. However, you can create and assign custom login policies. See Login policies.
Set the user as the publisher or as a remote user of the database for use in a SQL Remote system. See User permissions.

New user creation

See also