Sunday, November 23, 2008

AUTHENTICATION THROUGH OS

AUTHENTICATION THROUGH OS password defined by EXTERNALLY
---------------------------------------------------------------------------

step # 1

parameter must be like bellow

os_authent_prefix string OPS$

step # 2

know OS user name
SQL> select sys_context('USERENV','OS_USER') from dual;
SYS_CONTEXT('USERENV','OS_USER')
----------------------------------------------------------------------------
IBCSEBS07\Administrator

step # 3 user creation ( user name must be upper case)

SQL> create user "OPS$IBCSEBS07\ADMINISTRATOR" identified by externally;

User created.

SQL> grant connect,resource to "OPS$IBCSEBS07\ADMINISTRATOR";

Grant succeeded.

No comments: