Well, it *might* go this way:C:\>sqlplus sys/pw as sysdba
SQL> create user first.last identified by abc;
create user first.last identified by abc
*
ERROR at line 1:
ORA-01936: cannot specify owner when creating users or roles
SQL> create user "first.last" identified by abc;
User created.
SQL> connect scott/tiger
Connected.
SQL> grant select on emp to "first.last";
Grant succeeded.
SQL>
In other words: your DBA must have created this user using double quotes. You'll have to enclose such a username into double quotes too.
However, just like Anacedent said, it promises a little nice mess in your database.
] 
Blog
Search
Help
Members
Register
Login
Home
