protect from unauthorise user [message #462226] |
Wed, 23 June 2010 04:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raina
Messages: 10 Registered: June 2010 Location: new delhi
|
Junior Member |
|
|
hi to all,
i ve an query i.e.
when i m firing a command sqlplus "/as sysdba" any user who dont knw the password can connect with it and instance startup.i want to protect from unauthorise user who dnt knw the password of sys cannot connect with it?
Is it possible?
if yes then how?
could any one ve any idea?
|
|
|
Re: protect from unauthorise user [message #462234 is a reply to message #462226] |
Wed, 23 June 2010 04:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Not any user but only users that are the OS (sys)dba group.
So don't put any user in this group.
If you want to completly forbid "/ as sysdba" connection then use the following in your server sqlnet.ora file:
SQLNET.AUTHENTICATION_SERVICES = (none)
Regards
Michel
[Updated on: Wed, 23 June 2010 04:45] Report message to a moderator
|
|
|
Re: protect from unauthorise user [message #462404 is a reply to message #462226] |
Thu, 24 June 2010 02:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raina
Messages: 10 Registered: June 2010 Location: new delhi
|
Junior Member |
|
|
@Michael
thanks fr your reply..I ve already do this.I ve set the parameter
sqlnet.authentication_services=none.after that when i m firing a command sqlplus "/as sysdba". It gives error i.e.insufficient priviledge.nw I want to start an instance.
wht should i do to start an instance?
|
|
|
|
|
|
|
Re: protect from unauthorise user [message #462913 is a reply to message #462908] |
Mon, 28 June 2010 11:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
With the password!!!!!!!
If you don't know what it is then you're going to have to go back to using sqlplus "/as sysdba".
And will you please stop using IM speak. Use proper words.
|
|
|
|
Re: protect from unauthorise user [message #463211 is a reply to message #462226] |
Wed, 30 June 2010 04:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raina
Messages: 10 Registered: June 2010 Location: new delhi
|
Junior Member |
|
|
@Michel
I have set the parameter sqlnet.authentication_services=(NONE) in sqlnet.ora file.After that when I m firing a command sqlplus "/as sqlplus".It shows error like insufficient priviledge.Now i want to know how can I start an instance?
Is it possible to remove only sys user from ora_dba group?
If yes then how?
[Updated on: Wed, 30 June 2010 04:34] Report message to a moderator
|
|
|
Re: protect from unauthorise user [message #463213 is a reply to message #463211] |
Wed, 30 June 2010 04:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136607.jpg) |
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
C:\Documents and Settings\sriram>TYPE C:\oracle\product\10.2.0\db_3\network\admin\sqlnet.ora
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_3\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
C:\Documents and Settings\sriram>SQLPLUS / AS SYSDBA
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 30 15:05:50 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name: SYS AS SYSDBA
Enter password: ---Enter Your Password Here
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
[Updated on: Wed, 30 June 2010 04:34] Report message to a moderator
|
|
|
Re: protect from unauthorise user [message #463216 is a reply to message #462226] |
Wed, 30 June 2010 04:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raina
Messages: 10 Registered: June 2010 Location: new delhi
|
Junior Member |
|
|
I have alredy tried this.Its working.It is useful if only one database is running on your computer.If two database is running on a same computer then another will not work because we have set the parameter sqlnet.authentucation_services=(NONE) in sqlnet.ora file.
|
|
|
|
Re: protect from unauthorise user [message #463222 is a reply to message #463219] |
Wed, 30 June 2010 05:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raina
Messages: 10 Registered: June 2010 Location: new delhi
|
Junior Member |
|
|
I want that only I can able to start an instance.not other person.when I m firing a command sqlplus.It asked for username and password that password only I knw andIt works for all databases which are running on same computer.
|
|
|
|
|
|
Re: protect from unauthorise user [message #463232 is a reply to message #462226] |
Wed, 30 June 2010 05:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
raina
Messages: 10 Registered: June 2010 Location: new delhi
|
Junior Member |
|
|
example:
sqlplus sqlnet.authentication_services=(NONE)
after that
sql>sqlplus "/as sysdba"
error: insufficient priviledge
when i m trying again with sys password like this
sql>sqlplus sys/sys as sysdba
it gives error
error: insufficicent priviledge.
I want to connect sys with my own password.could you please tell me how can I connect with sys..I hope now its clear to you.
|
|
|
|
|