The script that Toad is generating for me would be the same, except that when it does the grant and synonym options, there are no quotes around the user name. So if I clone, I get:
create user "User.With.Dot" identified by userwithdot;
grant connect to User.With.Dot;
grant select on tables to User.With.Dot;
grant create any table to User.With.Dot;
create synonym User.With.Dot.emp_syn for scott.emp;
I imported the Toad options from 12.10, so unless something changed, it should be the same.
I just tried again. I got a “ORA-00933: SQL command not properly ended” error right away. I chose Ignore all and Yes to show the output which gave me:
SQL> SET DEFINE OFF
SQL> CREATE USER "TEST.USER"
IDENTIFIED BY Th1s_IS_$_T3st
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE IMDB_USER
ACCOUNT UNLOCK
User created.
SQL> -- 4 Roles for "TEST.USER"
SQL> GRANT CONNECT TO TEST.USER
GRANT CONNECT TO TEST.USER
Error at line 11
ORA-00933: SQL command not properly ended
SQL> GRANT IMDB_GENERAL_USER TO TEST.USER
GRANT IMDB_GENERAL_USER TO TEST.USER
Error at line 12
ORA-00933: SQL command not properly ended
SQL> GRANT IMDB_SECURITY TO TEST.USER
GRANT IMDB_SECURITY TO TEST.USER
Error at line 13
ORA-00933: SQL command not properly ended
SQL> GRANT TOAD_RESTRICTIONS_FULL TO TEST.USER
GRANT TOAD_RESTRICTIONS_FULL TO TEST.USER
Error at line 14
ORA-00933: SQL command not properly ended
SQL> ALTER USER "TEST.USER" DEFAULT ROLE ALL
User altered.
I hope this helps.
Lynn
From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Sent: Thursday, July 27, 2017 5:58 AM
To: toadoracle@toadworld.com
Subject: [Non-DoD Source] RE: [Toad for Oracle - Discussion Forum] Bug in Toad for Oracle 12.11.0.95
RE: Bug in Toad for Oracle 12.11.0.95
Reply by John Dorlon
Hey Lynn,
I just tried this here and for me it is working OK. I created this user and then cloned it to a user called "a.b". Can you make some changes to my script so that it will fail?
Thanks.
create user "User.With.Dot" identified by userwithdot;
grant connect to "User.With.Dot";
grant select on tables to "User.With.Dot";
grant create any table to "User.With.Dot";
create synonym "User.With.Dot".emp_syn for scott.emp;
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.