Database Reference
In-Depth Information
Public synonym are accessible to all the users provided they
have access to underlying object. The above statement will
create a employee synonym for a employees table in hr schema
in a remote sales database.
Example:
DROP SYNONYM offices;
We use DROP SYNONYM statement to drop the synonym
completely from the database. The underlying object will not get
removed.
I thing you must be thinking that I haven't discussed something
like ALTER SYNONYM. Actually, there is no such statement.
If you want to alter synonym just recreate it by first dropping it
and then using CREATE SYNONYM statement.
CREATE/ALTER USER, GRANT/REVOKE Statements
To install Oracle software on the machine you have to be the
member of OS (Operating System) SYSOPER or SYSDBA
group. Once you install Oracle software and have default
database created by Oracle Universal Installer. There will be two
users created at the end of creation of database. One is “sys”
with the password “change_on_install” and other one “system”
with the password “manger”. It's highly recommended that you
change these passwords since these are standard accounts and
everywhere is the same. It's also recommended that you should
create at least one more dba level account. We will learn in more
detail regarding the purpose of having a sys and system accounts
later in this topic.
To create a new user (schema) you should login to Oracle
Instance using one of the DBA's account and then use the
CREATE USER statement to create new user.
Search WWH ::
Custom Search