user creation in 9i

[castlerock]

hi,
I have created a user called citiph2 and i have not assigned any privilege for that. but when i try to connect the user as sysdba its getting connected.I am having oracle 9i database in Windows 2000 server.Have anyone faced this problem.

The following is the user creation procedure

SQL> create user citiph2 identified by a;

User created.

SQL> conn citiph2/a
ERROR:
ORA-01045: user CITIPH2 lacks CREATE SESSION privilege; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn citiph2/a as sysdba
Connected.
SQL> select tname from tab;

[Sameer]

When you create new user, to connect to the database using newly created user, you need atleast CREATE SESSION priviledge. In your case you haven't granted any priviledge, so it won't able to connect to database.

And when you connect as "citiph2/a as sysdba", it actually connets as SYS user and not as "citiph2" user. This behavior is because of your sqlnet.ora setting. i.e SQLNET.AUTHENTICATION_SERVICES =(NTS) parameter. When you set this parameter to NTS, it connects to database even though your newly created user doesn't have any priviledge.

Try execting SHOW USER when you connet as "citiph2/a as sysdba", it will show you, User is "SYS"

HTH

Sameer

[castlerock]

hi sammer,

How do i stop the user..then how shouldi set the parameter

SQLNET.AUTHENTICATION_SERVICES =

???

Thanks,
Ramesh

[Sameer]

You can comment this parameter

[castlerock]

Thanks !! Its working now

Thanks,
Ramesh