摘要:
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)