Howard J. Rogers wrote:
> Please don't do what these two replies suggest!
>
> SYSTEM is a powerful account that can do everything that SYS can do, with
> the only exception being that privileged actions (startup, shutdown, backup,
> recover, create database) can only be done by SYS.
>
> And that's the way it should stay. SYSTEM should not ever be granted
> privileged action status.
>
> For [at least] one very good reason: anything granted by SYS, anything
> created by SYS, can never be exported. If you get into the habit of logging
> on as a privileged user (which is what would happen if you granted SYSDBA to
> SYSTEM) then you are going to create things and grant things which are then
> forever locked within that database, and not exportable. It's a severe
> compromise of database recoverability and portability, and you'd be insane
> to go for it.
>
> Use SYS to do startups and shutdowns (etc). And use SYSTEM for all other
> day-to-day database management. Use the accounts in the way they were
> designed... because they were designed that way for a reason.
>
> Regards
> HJR
>
>
>
> "Chief" <chiefgecko_at_mail.com> wrote in message
> news:71497b46.0305191323.62ef5e80_at_posting.google.com...
>
>>"John M" <bali1a_at_freemail.hu> wrote in message
>
> news:<bt9ya.7750$FJ4.81567_at_news.chello.at>...
>
>>>Hello,
>>>
>>>I have just installed an Oracle 8i. I want to use DBA Studio to connect
>>
> to
>
>>>my DB. I want to login as SYSDBA with the default system/manager login.
>>
> But
>
>>>I become a message:
>>>ORA-01031: insufficient privileges.
>>>I have installed this Oracle version to an other PC too, and there I can
>>>login.
>>>
>>>What can be the problem?
>>>
>>>Thanks!
>>
>>Connect to the 'sys' username using
>>sqlplus "/ as sysdba"
>>or
>>using DBA Studio connect to SYS using password with the "AS SYSDBA"
>>option.
>>
>>Then...
>>
>>execute the sql: GRANT SYSDBA TO SYSTEM
>>If this succeeds, then connect to the SYSTEM username using the "AS
>>SYSDBA" option. If you still get ORA-01031 post a reply and someone
>>can talk you through creating a password file and/or setting a
>>init.ora param.
>>
>>Ciao, Tim...
>
>
>
Sorry - Howard is right of course, I should have elaborated
on the "Not considered a Good Idea (tm), though..." as the
header stated newbe - which completely slipped through
--
Regards, Frank van Bortel
Received on Wed May 21 2003 - 14:51:42 CDT
