No user should be allowed to consume the resources or cause lots of work
for anyone else. It's unprofessional and just rude!
Write a before trigger (on DDL) to prevent anyone (I use OSUSER) not on
the approved list to be denied DDL commands (create, drop, alter, etc).
The reason I use the OSUSER, is there are users that (sigh) have the
schema owner and I can't prevent that (at this time) but I see who they
are logged in as at the OS level and only a couple of us are allowed ddl
everyone else is voted off the island.
Amy Loukota
Oracle Certified DBA
TriWest HealthCare Alliance
15451 N. 28th Ave.
Phoenix, AZ 85053
[Email address protected]
work: 602-564-2452
"The best job goes to the person who can
get it done without passing the buck
or coming back with excuses."
-- Napoleon Hill, Author and Speaker
-----Original Message-----
From: Strelzyk Stephen
[mailto:oracledba-ezmlmshield-x20551589.[Email address protected]
Sent: Thursday, August 31, 2006 9:17 AM
To: LazyDBA Discussion
Subject: RE: svrmgrl with Oracle 10g
I don't use it either, but one of my users (developer connecting to the
database) keeps using svrmgrl. Do you think it is worth writing the
code to check the session on connection, and kill the connection. The
guy is using it to create his table definitions,etc. I will eventually
have to approve it anyway, and if it is wrong, my workload goes up
tremendously. What does everyone think?
-----Original Message-----
From: Hans
[mailto:oracledba-ezmlmshield-x57958084.[Email address protected]
Sent: Thursday, August 31, 2006 4:09 AM
To: LazyDBA Discussion
Subject: RE: svrmgrl with Oracle 10g
I don't use svrmgrl for the same reason I no longer use SQL*dba : it is
unsupported and deprecated.
Why would you want to use an unsupported tool; also SQL*Plus has more
possibilities.
Hans
-----Original Message-----
From: Strelzyk Stephen
[mailto:oracledba-ezmlmshield-x65080020.[Email address protected]
Sent: woensdag 30 augustus 2006 20:44
To: LazyDBA Discussion
Subject: svrmgrl with Oracle 10g
I know that svrmgrl was deprecated since 8.1.7. One of my users still
has svrmgrl, and continues to use it to work in our 10g database. Does
anyone see a problem with this? I ran into one issue where svrmgrl
reported different information regarding column types when describing a
table. What is the groups experience?
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained within this transmission is proprietary and protected pursuant to federal regulations; it is intended only for the use of the individual or entity to which it is addressed.
If you are not the intended recipient, you are hereby notified that any distribution, copying, disclosure, use of, or reliance on, the contents of this transmission is strictly prohibited.
If you have received this communication in error, please notify the sender immediately by telephone and permanently delete the original message, attachments and all copies. Thank you.
Oracle LazyDBA home page