SQL Maestro Group / Products / Oracle / Oracle Maestro / Documentation

Oracle Maestro online help

User profile is a set of limits on database resources. If you assign the profile to a user, then that user cannot exceed these limits. Use profiles to limit the database resources available to a user for a single call or a single session.

New user profile are created within Create User Profile Wizard. In order to run the wizard you should either

•	select the Object \| Create Database Object... main menu item;

•	select the user profile icon in the Create Database Object dialog

•	select the user profile list or any object from that list in the explorer tree;

•	select the Create New User Profile... item from the popup menu

•	open the schema in Schema Editor and the User Profiles tab there;

•	press the Insert key or select the Create New User Profile item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To create a new user profile with the same properties as one of the existing user profile has:

•	select the Object \| Duplicate Database Object... main menu item;

•	follow the instructions of Duplicate Object Wizard.

User profiles can be edited within User Profile Editor. In order to run the editor you should either

•	select the user profile for editing in the explorer tree (type the first letters of the user profile name for quick search);

•	select the Edit User Profile... item from the popup menu

•	open the database in Database Editor and the User Profiles tab there;

•	select the user profile to edit;

•	press the Enter key or select the Edit User Profile item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

You can change the name of the user profile using the Rename User Profile dialog. To open the dialog you should either

•	select the user profile to rename in the explorer tree;

•	select the Rename User Profile item from the popup menu

•	open the database in Database Editor and the User Profiles tab there;

•	select the user profile to rename;

•	select the Rename User Profile item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To drop a user profile:

•	select the user profile to drop in the explorer tree;

•	select the Drop User Profile item from the popup menu

•	open the schema in Schema Editor and the User Profiles tab there;

•	select the user profile to drop;

•	press the Delete key or select the Drop User Profile item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.