
102
|
Toad Pocket Reference for Oracle
Managing Users
Managing all of the users across multiple databases can be a
daunting task, even for a skilled DBA. Toad offers several
tools to help make your job more manageable. The Users tab
available from the Schema Browser provides a centralized
place to perform all of your user administration tasks.
Create User and Alter User
As with Toad’s other Create and Alter Object dialogs, the
Create User and Alter User functions allow you to set up a
user account in one fell swoop. Not only can you set up the
desired CREATE USER statement, you can also configure the
user account’s system privileges, object grants, quotas, and
resource groups. When you do, Toad will create a script and
send it to Toad’s Script Engine to create the user account.
On the Tablespace tab, Toad has an option to set your selec-
tions for the user’s default and temporary tablespaces as
defaults for all future Create User sessions in Toad for the
current database. Enable the Set Tablespace names as defaults
for all User Creates option to have Toad remember your
selections.
Perhaps you have an existing user account that you wish to
use as a model for creating a new account. In the Schema
Browser, right-click on the existing user on the lefthand side
of the Schema Browser and select Clone/Copy. Toad will
allow you to specify the name of the new account and the
authentication method and/or password. ...