-
Don't take my word for it...
Enterprise Manager
Enterprise Manager is Oracle's database administration tool that provides a graphical user interface (GUI). Enterprise Manager provides administrative functionality for distributed databases through an easy-to-use interface. You can use Enterprise Manager to:
Administer multiple databases. You can use Enterprise Manager to administer a single database or to simultaneously administer multiple databases.
Centralize database administration tasks. You can administer both local and remote databases running on any Oracle platform in any location worldwide. In addition, these Oracle platforms can be connected by any network protocols supported by Oracle Net.
Dynamically execute SQL, PL/SQL, and Enterprise Manager commands. You can use Enterprise Manager to enter, edit, and execute statements. Enterprise Manager also maintains a history of statements executed.
Thus, you can reexecute statements without retyping them, a particularly useful feature if you need to execute lengthy statements repeatedly in a distributed database system.
Manage security features such as global users, global roles, and the enterprise directory service.
http://download-west.oracle.com/docs...epts.htm#12425
I remember when this place was cool.
-
1
Overview of Oracle Enterprise Manager
Oracle Enterprise Manager combines Oracle's system management Console, common services, and integrated platform graphical tools. It provides an integrated set of standard database administration applications to help automate and simplify the common daily tasks of administrators. These supplemental applications focus on specific areas of database administration, helping administrators with their daily and routine tasks of managing databases and other services and keeping them operational.
http://download-west.oracle.com/docs...ew.htm#1005618
I remember when this place was cool.
-
Database Administration Functionality
Oracle Database Administrators (DBAs) are commonly required to perform tasks such as creating users, performing backups, adding tablespaces or datafiles, managing database objects, and changing instance parameters.
The Oracle Enterprise Manager Console offers database administration functionality that help automate and simplify the daily tasks of a DBA:
I remember when this place was cool.
-
Originally posted by Mr.Hanky
No, the point is that devlopers should not be using OEM.
Technically you CAN use a hair dryer in the bathtub, doesn't mean it is a good idea. He does not have admin rights on his PC for a reason.
Can you imagine the nightmare of having a team of decelopers all using OEM, click click click, oops....wha happened......let's call the DBA for a recovery.
Foot in my mouth huh, yeah ok whatever you say developer boy.
You are just another frustrated developer that is dying to wear the Daddy pants.
Explain how I can muck up a database with the following privileges. And quit yer bitchin'.
Its unbecoming of a Junior DBA such as yourself!
Code:
TABLE_NAME PRIVILEGE
------------------------- ------------------------------
DBA_BLOCKERS SELECT
DBA_COL_PRIVS SELECT
DBA_DATA_FILES SELECT
DBA_DDL_LOCKS SELECT
DBA_DML_LOCKS SELECT
DBA_EXTENTS SELECT
DBA_FREE_SPACE SELECT
DBA_ROLES SELECT
DBA_ROLE_PRIVS SELECT
DBA_ROLLBACK_SEGS SELECT
DBA_SEGMENTS SELECT
DBA_SYNONYMS SELECT
DBA_SYS_PRIVS SELECT
DBA_TABLESPACES SELECT
DBA_TAB_PRIVS SELECT
DBA_VIEWS SELECT
DBA_WAITERS SELECT
V_$ACCESS SELECT
V_$CIRCUIT SELECT
V_$DATAFILE SELECT
V_$DB_OBJECT_CACHE SELECT
V_$DISPATCHER SELECT
V_$EVENT_NAME SELECT
V_$FILESTAT SELECT
V_$LATCH SELECT
V_$LATCHHOLDER SELECT
V_$LIBRARYCACHE SELECT
V_$LOCK SELECT
V_$LOCKED_OBJECT SELECT
V_$OPEN_CURSOR SELECT
V_$PARAMETER SELECT
V_$PROCESS SELECT
V_$QUEUE SELECT
V_$ROLLNAME SELECT
V_$ROLLSTAT SELECT
V_$SESSION SELECT
V_$SESSION_EVENT SELECT
V_$SESSION_LONGOPS SELECT
V_$SESSION_WAIT SELECT
V_$SESSTAT SELECT
V_$SESS_IO SELECT
V_$SGA SELECT
V_$SGASTAT SELECT
V_$SQL SELECT
V_$SQLAREA SELECT
V_$SQLTEXT_WITH_NEWLINES SELECT
V_$SQL_PLAN SELECT
V_$SQL_PLAN_STATISTICS SELECT
V_$SQL_PLAN_STATISTICS_ALLSELECT
V_$STATNAME SELECT
V_$SYSSTAT SELECT
V_$TRANSACTION SELECT
V_$WAITSTAT SELECT
53 rows selected.
PRIVILEGE
------------------------------
ALTER SESSION
CREATE SESSION
-
Gandolf; All kidding aside, Lecco is a very powerful SQL tuning tool. It will take you written sql and offer multiple re-write suggestion, analyze them and even batch run them against the database to see which is optimal. You can get a free trial here...
It makes Bozo's like me look like brilliant SQL tuners.
http://www.quest.com/sql_optimizer_for_oracle/index.asp
Last edited by Mr.Hanky; 01-13-2005 at 12:06 PM.
I remember when this place was cool.
-
Ps. I was right and you ALL were wrong, HA HA!
I remember when this place was cool.
-
Ok guys. I just tested this.
You need to have select any privilege to connect from OEM.
-
Originally posted by thomasp
Ok guys. I just tested this.
You need to have select any privilege to connect from OEM.
yes and what can you break with select privelege?
absolutely nothing.
Anyone can use oem and not be able to break anything, simple as that
-
Originally posted by davey23uk
yes and what can you break with select privelege?
absolutely nothing.
Anyone can use oem and not be able to break anything, simple as that
While I admire your tenacity I feel it is grossly misplaced.
OEM is a DATABASE MANAGEMENT UTILITY, PERIOD
It is a DBA tool, period.
I remember when this place was cool.
-
I meant select any dictionary privilege.
So, do you have that granted to you. If then , I dont see any problem.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|