Because Oracle seems to like to practice security-by-obscurity (stupidly, IMHO). I think a DBA should have complete control of a DB, but also be completely auditable. OpenVMS comes to mind. e.g. You can delete audits in VMS, but the record of your delete is also audited, and the deletion of that audit delete, etc.
Anyway, there are a few ways to get around this "security" if you have access to a DBA account in the DB. Check out http://www.orafaq.com/faqdbase.htm under "How does one switch to another user in Oracle?". <rant> Why have security if it can easily be defeated? It just makes my job harder, take longer, and more prone to screwups (human error). And Oracle doesn't audit everything, so a sinister DBA can (almost) completely cover their tracks. Stupid, stupid, stupid. </rant> HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Friday, March 01, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Hello Gurus, Just curious to know why Oracle does not allow one to grant select privileges on the fixed tables to other users? Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
