2012年6月29日
摘要: In some case, we may want to drop user.so we can use this sql as follow: drop user username cascade; but if the user is connected, we can't drop it.so 阅读全文
posted @ 2012-06-29 17:04 子虚乌有 阅读(229) 评论(0) 推荐(0)
摘要: select 'drop user "' || username || '" cascade; ' from dba_users WHERE username like 'name%'; sql server browser must start, if you want use remote sq 阅读全文
posted @ 2012-06-29 11:17 子虚乌有 阅读(219) 评论(0) 推荐(0)