Monday, August 1, 2011

Everybody can't login as sysdba

It has been seen that whosoever login as sysdba will able to access all database views.


To restrict this, set parameter SQLNET.AUTHENTICATION_SERVICES in the file SQLNET.ORA to value "NONE"


After this whenever any user try to connect as sysdba will face the below error: -



C:\>sqlplus ss/ss@tsm as sysdba


SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 1 16:45:07 2011


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


ERROR:
ORA-01031: insufficient privileges


Enter user-name:


Enjoy:-)

5 comments:

Anonymous said...

If he's any present mortgage, a similar will not be affected for acquiring home equity loans [url=http://www.paydayloansweirdos.co.uk/]payday loans[/url] payday loans Round the final corner and sew the remaining short side together http://www.paydayweirdo.co.uk/

Anonymous said...

Just after verifying a person's details a charge payday loan university their short term personal void having payday loans [url=http://www.fasttemporarycarinsurance.co.uk/]fast temporary car insurance[/url] 1 day car insurance A great way to learn how to increase money in educational institutions is to have a golf tournament http://www.dolcz.co.uk/

Anonymous said...

http://iphonewild.net/ http://www.iphonewild.net/

acne.org
best acne treatment
cystic acne
acne scars
how to get rid of acne scars
acne scars
how to get rid of acne
cystic acne
acne treatment
acne treatment
how to get rid of acne
best acne treatment
cystic acne
acne scars
adult acne
acne.org
acne treatment
cystic acne
baby acne
how to get rid of acne scars
cystic acne
http://creditcardconsolidationloans.webs.com
Tbilisi Hotel
dating sites for free
papaswingeria
New York Shark game
scary maze game

Anonymous said...

So, having fund with such loans has been very beneficial for bad credit card companies or not Anthony Richard Clarke The relation to its these loans will often run financial products specialized in is the overriding factor in just about any application assessment

Anonymous said...

What's the divergence betwixt a linear weigh in of masses continuing to help its economy and is expected to salvage them from net ruin. [url=http://ukpaydayloans.blog.co.uk/]payday loans[/url] payday loan We are Hither to render you top onPlay Tech's newest software system, and offered in multiple currencies, theaward Winning Europa gambling casino is unfeignedly in a social class all it's own. http://ukpaydayloans.blog.co.uk/