Hi all,
In 8i
Is there a way to restrict user with dba role to drop system tbs ? while not
interrupting oracle work with that tbs.
I always think of triggers which is mean we have to protect those
triggers... to cover security hole : (
perhaps Just recreating oracle dba role without drop any granted ...
Do you guys have any experience protecting this tbs ?
regards
Sinardy
-----Original Message-----
Kirti
Sent: Monday, 30 July 2001 10:57 PM
To: Multiple recipients of list ORACLE-L
Joe,
I tried it already with 9.0.1.
Won't let you drop system. ORA-1550 jumps out :)
Regards,
- Kirti
> -----Original Message-----
> From: JOE TESTA [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 9:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:no create system tbs ?????
>
> i thought i tried to "drop" the system tablespace before as an experiment
> and it didnt work, maybe its an 9i feature, i'll have try it later today.
> :)
>
> Joe
> working on IOUG 2002 abstracts
>
> >>> [EMAIL PROTECTED] 07/30/01 10:05AM >>>
> No the alter can only work on an existing tablespace. But on a lighter
> note,
> from the past, I once had an interviewee who stated that one can "drop and
> create the system tablespace". Now this is somewhat true as there is no
> prohibition in Oracle from doing so, but the consequences are (let's just
> say
> REAL scary)!!!!!
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Sinardy" <[EMAIL PROTECTED]>
> Date: 7/27/2001 8:20 PM
>
> Hi all,
>
> When I am using dbassist to create "create DB script",
>
> First of the script is for something like:
> CREATE DATABASE
>
> ..
> redo bla bla
> datafile
> logfile
>
> ;
>
> Second script
>
> ALTER TABLESPACE SYSTEM
> DEFAULT STORAGE
>
> .
> .
> .
> .
>
> CREATE TABLESPACE tool
>
> ...
> ..
>
> CREATE TABLESPACE rbs
>
> ________________________________
>
> My question is in second script, where we create the tablespace call
> system
> ?
> alter tablespace will not create tablespace, am I right ?
>
>
> Regards,
> Sinardy
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
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).