开发者

Unable to drop a user

开发者 https://www.devze.com 2023-02-04 02:05 出处:网络
I want to drop a 开发者_JS百科user like \'salman\'. I have tried this syntax: drop user \"\'salman\'\"

I want to drop a 开发者_JS百科user like 'salman'. I have tried this syntax:

drop user "'salman'"

but it is not dropping.

Secondly, I want to drop a single database by command not from dbca. Is it possible?


You may need the DROP USER system privilege. But if you have that, the syntax should be:

DROP USER salman;

If you want to drop the user and all of the objects he owns:

DROP USER salman CASCADE;
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号