Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




EnterpriseDB: Create Public Synonym Wizard
Oracle Tips by Burleson

A synonym is a pointer to other database objects.  EnterpriseDB only supports public synonyms.  The create public synonym wizard (Figure 5.28) allows you to create public synonyms.

Figure 5.28: Create Synonym Wizard

The synonym name can be any name that follows object-naming standards.  Chose the Object Schema and Object Name that the synonym points to from the drop down lists.

You may add a synonym for a package but you cannot use this wizard to create a synonym for a procedure or function within a package.  This differs from Oracle style synonyms.

Create Tablespace Wizard

The create tablespace wizard (Figure 5.29) allows you to create tablespaces on operating systems that support symbolic links (Linux primarily).  For maintenance, you can group objects within a specific tablespace.

Figure 5.29: Create Tablespace Wizard

Name and Location are mandatory.  Name is the object name and is what you would refer to in DDL.  Location is the physical location on the file system where the tablespace will be stored.

Create User Wizard

The create user wizard (Figure 5.30) allows you to create database users.   It is recommended, for security reasons, that you create users to do your normal day-to-day job and to not use the enterprisedb user at all.  It is also considered a best practice to assign users the least privileged access that allows them to do their jobs.

Figure 5.30: Create User Wizard

The only required parameter is the user name.  This must follow EnterpriseDB Advanced Server naming standards.

The optional parameters include:

* Default Schema – Creates a new schema with the same name as the user (emulates Oracle user creation)

* Assign a Default Schema – The schema that will be used, by default, when this user creates database objects (emulates Oracle user creation)

* Password and Password Expiry – Does this user use a password (recommend) and if so, does it expire? 

* System level creation privileges – Can this user create databases or other users (if yes to both, this user is a DBA-ish type user)

* Groups/Roles - The final set of optional parameters is which groups does this user belong to.  This is user defined.  By default, the user would not belong to any role.

Create Role Wizard

Roles and groups are synonymous.  Roles are a way to logically group users.  Semantically, some would say that a Group has login privileges and a role does not.  The create role wizard (Figure 5.31), allows you to create roles. 

Figure 5.31: Create Role Wizard

The only required parameter is the role name.  You may also optionally assign users to the role.

Figure 5.32 displays some of the newly created objects (from the steps above).

Figure 5.32: Created Objects Example


This is an excerpt from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter