Re: [OT] Lack of IEEE values in Oracle

From: TC <no_at_email.please>
Date: Mon, 05 Nov 2001 10:54:29 GMT
Message-ID: <01c165e8$13a6c880$0f8850d2@pentium>

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in article <3be66055$0$8514$ed9e5944_at_reading.news.pipex.net>...

>> "Oracle allows you to create a user name with a "." (dot) in it"

>
> SQL> create user niall.litchfield identified by test;
> create user niall.litchfield identified by test
> *
> ERROR at line 1:
> ORA-01936: cannot specify owner when creating users or roles

You're assuming that by "user name", he meant "object owner". I think he meant "an object name assigned by the user". With that definition, you *can* create a user name containing a dot:

    create user "niall.litchfield" (etc.)

TC Received on Mon Nov 05 2001 - 04:54:29 CST