Database Administration (MOSC)

MOSC Banner

How to get identified globally to work?

edited Mar 16, 2012 2:31AM in Database Administration (MOSC) 3 commentsAnswered
Greetings All,
I'm looking into user accounts that are "identified globally" (my Developers are complaining that they have to remember more than one password! <sigh/>) but without much luck - I've obviously missed  something so any pointers in the right direction would be greatly appreciated.
create user fred
identified globally as 'CN=Frod.Flintstein, OU=???, ...  DC=???'
default tablespace users
temporary tablespace temp
account unlock ;
grant create session to fred ;
Sqlplus fails with
sp2-0306: Invalid Option
(really helpful message - not!  How do I track this one down?)

All other connections (from other applications) fail with
ORA-01017: invalid username/password; logon denied.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center