Sunday, March 17, 2013

dba_group and user identified externaly


1>dba_group

I installed oracle as user-mani windows account
then I tried to login from aother administrator account as
sqlplus / as sysdba but not able to connect .

here come dba_group

I. right clicked my computer>manage>localusersgroups>add administrator
to dba_group and all start working ..:)



2>user identified externaly
use something other than data dictoinaly by oracle for authentication


echo %username%
hostname
echo %userdomain%


create user "OPS$MANI-PC\Mani" identified externally;
grant connect,resource to "OPS$MANI-PC\Mani";


then you will be able to connect database when you are looged into system as
use Mani without any password simply bu

sqlplus /

No comments: