Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    40

    Unanswered: can't connect to user with a space in the login name

    i can create a user with a space in the name

    create user "full name" identified by blah;

    but when i want to connect to "full name" using sqlplus it doesn't work. i've been trying:

    sqlplus "full name"/blah

    does anyone know how to connect to "full name"

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    SQL> create user "Full Name" identified by blah;

    User created.

    SQL> grant create session to "Full Name";

    Grant succeeded.

    SQL> connect "Full Name"/blah@V92
    Connected.
    SQL> select user from dual;

    USER
    ------------------------------
    Full Name


    What error do you get?

  3. #3
    Join Date
    Jan 2004
    Posts
    40
    SQL> create user "Full Name" identified by blah;

    User created.

    SQL> grant create session to "Full Name";

    Grant succeeded.

    SQL> connect "Full Name"/blah
    Connected.
    SQL> exit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    C:\>sqlplus "Full Name"/blah

    SQL*Plus: Release 8.1.7.0.0 - Production on Mon Apr 5 13:26:41 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
    where <logon> ::= <username>[/<password>][@<connect_string>] | /
    Enter user-name:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •