Dumb Oracle client install question

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

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

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:

Quote:

---

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

Ps. I was right and you ALL were wrong, HA HA!

Ok guys. I just tested this.
You need to have select any privilege to connect from OEM.

Quote:

---

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

Quote:

---

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 meant select any dictionary privilege.

So, do you have that granted to you. If then , I dont see any problem.