Connecting as SYSDBA gives the user these abilities plus unrestricted privileges to do anything to a database or the objects within a database (including, CREATE, DROP, and DELETE). SYSDBA puts a user in the SYS schema, where they can alter data dictionary tables. When you connect with SYSDBA or SYSOPER privileges, you connect with a default schema, not with the schema that is generally associated with your username. For SYSDBA this schema is SYS; for SYSOPER the schema is PUBLIC.
Consider revoking sysdba from system.
LS
"640KB ought to be enough for anybody." - Bill Gates, 1981
----- Original Message ----
From: Dharmesh_Chauhan <oracledba-ezmlmshield-x20289272.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Wednesday, October 10, 2007 12:03:15 AM
Subject: RE: connect as sysdba
Try this also
System/[password]@[sid] as sysdba
-----Original Message-----
From: Bheemsen Aitha
[mailto:oracledba-ezmlmshield-x11829870.[Email address protected]
Sent: Tuesday, October 09, 2007 9:45 PM
To: LazyDBA Discussion
Subject: RE: connect as sysdba
Thanks to all those who responded.
1. Yes, I am connecting from remote machine.
2. Connecting with "system as sysdba" on the server itself works.
3. On the remote machine I am getting "insufficient privileges" error.
Thanks
B
----Original Message-----
From: Dean Hamann
[mailto:oracledba-ezmlmshield-x2324326.[Email address protected]
Sent: Tuesday, October 09, 2007 4:18 AM
To: LazyDBA Discussion
Subject: Re: connect as sysdba
grant sysdba to system (if you want to use it as such), in order to do
that you will need to make sure you have a password file, then you
should be able to connect from a remote machine.
Dean
M. Dean Hamann
Associate Director, Administrative Computing Services
Information Systems
University of Indianapolis
317-788-3238
Bheemsen Aitha wrote:
> Hi,
>
>
>
> I am able to connect to sqlplus using "system as sysdba" at Unix
prompt
> on the server. But I am not able to connect using "system as sysdba"
in
> sqlplus from my machine on Windows to the same db.
>
>
>
> Is it something to do with tnsnames or sqlnet?
>
>
>
> Any help is appreciated.
>
>
>
> Thanks
>
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
Oracle LazyDBA home page