Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079