删除用户名中带单引号的 oracle-user

Question

通过一个错误的脚本，我在 Oracle 9i 系统上创建了一个用户名并用单引号引起来（即他的用户名是“用户名”，而不是用户名）。 现在我想删除该用户。 “DROP USER 'username'”、“DROP USER \'username\'”和“DROP USER (SELECT username FROM all_users where user_id = 123)”都不起作用。 我如何摆脱该用户？

Answer 1

create user "'bla'" identified by bla;

drop user "'bla'";

Answer 2

根据 Oracle 文档.. 。

“带引号的标识符开始和结束
带双引号 (")。如果
您使用以下方式命名模式对象
带引号的标识符，那么您必须使用
每当双引号
你引用那个对象。”

所以这个......

DROP USER "username" CASCADE;

Answer 3

我知道这是一篇旧帖子，但对于任何因搜索此问题而偶然发现此问题的人来说 - 问题似乎是数据库触发器在删除用户上触发。
我已经发布了我为 Oracle XE 找到的解决方案（可能与其他 10g 版本相同）
这里

希望有人觉得这很有用，

迈克

Answer 4

尝试 DROP USER "'username'" 或 DROP USER ''username''。 （注意最后的引号都是单引号）

Answer 5

我不太了解 Oracle，但是您可以尝试将其用双引号引起来吗？

（如果这个答案有误我会删除）

Answer 6

以下代码可能对您有帮助：

declare 

   sel_username varchar2(30); 
   r_user_id    varchar2(30); 
   r_username   varchar2(30); 
   user_cmd     varchar2(200); 

BEGIN
/* 
   This procedure will delete a single user_id and can be used to delete a user 
   with none displayable characters in the name 

   **Replace** the user_id  in this script to that you want to delete !! 

   Author: Ulrich Henkenjohann  -  March 2010 / tested on ORACLE 10.2.0.4 

*/      
-- select the username for a special user_id. Ther username may contain none displayed characters

   select username into sel_username from dba_users where user_id = 34; 
   select user_id, username into r_user_id , r_username from dba_users where username = sel_username ; 
   DBMS_OUTPUT.PUT_LINE('Selected user: ' || r_user_id || ' ' || r_username); 

-- If a test is needed, an alter passwort command may be usefull 
-- user_cmd := 'ALTER USER "' || r_username || '" IDENTIFIED BY PASSWORDX '; 

-- Drop the selected user 

   user_cmd := 'DROP USER "' || r_username || '" CASCADE '; 
   DBMS_OUTPUT.PUT_LINE('Executing user_cmd: ' || user_cmd ); 
   execute immediate user_cmd ; 

END;
/

Answer 7

再次采用更好的格式：

declare 

   sel_username varchar2(30); 

   r_user_id    varchar2(30); 

   r_username   varchar2(30); 

   user_cmd     varchar2(200); 

BEGIN

/* 

   This procedure will delete a single userid and can be used to delete a user 
   with none displayable characters in the name 

   **Replace the user_id  in this script !!** 

   Author: Ulrich Henkenjohann  -  March 2010 / tested on ORACLE 10.2.0.4 

*/      
-- select the username for a special user_id. Ther username may contain none displayed characters

   select username into sel_username from dba_users where user_id = 34; 

   select user_id, username into r_user_id , r_username from dba_users where username = sel_username ; 

   DBMS_OUTPUT.PUT_LINE('Selected user: ' || r_user_id || ' ' || r_username); 

-- If a test is needed, an alter passwort command may be usefull 

-- user_cmd := 'ALTER USER "' || r_username || '" IDENTIFIED BY PASSWORDX '; 

-- Drop the selected user 

   user_cmd := 'DROP USER "' || r_username || '" CASCADE '; 

   DBMS_OUTPUT.PUT_LINE('Executing user_cmd: ' || user_cmd ); 

   execute immediate user_cmd ; 

END;
/