OraFAQ Forum: Server Administration » forcing a user to type password when he tries to connect "conn /as sysdba"

Home » RDBMS Server » Server Administration » forcing a user to type password when he tries to connect "conn /as sysdba"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

forcing a user to type password when he tries to connect "conn /as sysdba" [message #144799]

Fri, 28 October 2005 07:14

kadedadba
Messages: 2
Registered: October 2005
Location: mumbai

Junior Member

hi..
i have to force the dba allso to enter a password when he connect to database as dba...
how to force the user to enter a password ..when he tries to connect "conn /as sysdba"
.....
i am using 9i oracle on linux...
i am new to dba..please help me..

Report message to a moderator

Re: forcing a user to type password when he tries to connect "conn /as sysdba" [message #144803 is a reply to message #144799]

Fri, 28 October 2005 07:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>force user to enter a password ..when he tries to connect "conn /as sysdba"

First, the regular users should be allowed to login as sysdba.
You can do the above only if you are a member of DBA group (UNIX group) or explicityly granted. So only OS user ORACLE should be in DBA group.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1167

Edit :
First, the regular users should be allowed to login as sysdba.
should be read as
First, the regular users should NOT be allowed to login as sysdba.

[Updated on: Wed, 02 November 2005 10:03]

Report message to a moderator

Re: forcing a user to type password when he tries to connect "conn /as sysdba" [message #145331 is a reply to message #144803]

Wed, 02 November 2005 09:57

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Mahesh Rajendran wrote on Fri, 28 October 2005 07:30

>>force user to enter a password ..when he tries to connect "conn /as sysdba"

First, the regular users should be allowed to login as sysdba.
You can do the above only if you are a member of DBA group (UNIX group) or explicityly granted. So only OS user ORACLE should be in DBA group.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1167

> First, the regular users should be allowed to login as sysdba.

You mean ...

First, the regular users should NOT be allowed to login as sysdba.

Report message to a moderator

Re: forcing a user to type password when he tries to connect "conn /as sysdba" [message #145334 is a reply to message #145331]

Wed, 02 November 2005 10:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Sanjay,
Thanks for pointing.
That was a typo.

Report message to a moderator

Previous Topic:	Oracle Database 10g Express Edition
Next Topic:	Solaris 9, 10g - move all object from one tablespace to another

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:27:07 CST 2025