 |
|
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. |
