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:-)

4 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...

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/