| Login as sysdba [message #439449] |
Sat, 16 January 2010 23:52  |
goracle9
Messages: 136
Registered: December 2006
|
Senior Member |
|
|
Dear All,
when login in production server like
it's not asking password, i feel this is insequre
let me know how to sequre the database from unauthorised person
thanks.
regards
|
|
|
|
|
|
|
|
| Re: Login as sysdba [message #439454 is a reply to message #439453] |
Sun, 17 January 2010 01:23  |
 |
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
At OS prompt, type "groups", all users are in a group defined at Oracle installation generically named SYSDBA OS group and which is usually named "dba" but it is not mandatory (as I said you choose it at installation time). Remove your users from this OS group.
Regards
Michel
[Updated on: Sun, 17 January 2010 01:23] Report message to a moderator |
|
|
|
|
|
| Re: Login as sysdba [message #483943 is a reply to message #439478] |
Thu, 25 November 2010 15:02 |
oracula
Messages: 2
Registered: November 2010
|
Junior Member |
|
|
remember that if the DBA has access to this sqlnet.ora, he can any time change definition back to be able logon without password.
DBA can also redefine enviroment variable TNS_ADMIN refering to own sqlnet.ora file
|
|
|
|
| Re: Login as sysdba [message #483956 is a reply to message #483943] |
Thu, 25 November 2010 20:28 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>DBA can also redefine enviroment variable TNS_ADMIN refering to own sqlnet.ora file
ANYONE can define TNS_ADMIN for their own process.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
