if you have to restrict someone with DBA role from dropping the system
ts, take away the dba role since that person EVIDENTLY shouldn't have
it.
joe
Sinardy wrote:
>
> Hi all,
>
> In 8i
> Is there a way to restrict user with dba role to drop system tbs ? while not
> interrupting oracle work wit
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 gran
The actual response to this is...
What is an Oracle database and instance? What does it require?
To have a running Oracle database you need:
A pfile (init.ora) to set up the SGA
At least one control file (location defined in pfile created by the
create database command)
At
Kirti, thanks :)
joe
>>> "Deshpande, Kirti" <[EMAIL PROTECTED]> 07/30/01 09:52AM >>>
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,
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 s
system tablespace is create when the create database happens, all the
alter tablespace does is alter the stroage parameters.
joe
Sinardy wrote:
>
> Hi all,
>
> When I am using dbassist to create "create DB script",
>
> First of the script is for something like:
> CREATE DATABASE
>
> .
In the first script, with the statement "create database", you have a
datafile definition. That statement, and the datafile definition are the
create of the system tablespace.
>From: "Sinardy" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL
Sinardy:
The SYSTEM tablespace is created with the CREATE DATABASE statement. Its
datafile is the file set out in the DATAFILE portion of the statement.
Jon Walthour
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, July 28, 2001 12:20 AM