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.
Sunday, November 23, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment