search

Home >Database >Mysql Tutorial >Oracle错误 ORA-01950 对表空间“system”无权限

Oracle错误 ORA-01950 对表空间“system”无权限

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:09:192689browse

Oracle错误 ORA-01950 对表空间quot;systemquot;无权限

问题：在scott下建表，报错 ORA-01950 对表空间"system"无权限

解决方法：

在pl/sql下，登录system的帐号，新建一个sql文件，

输入SQL> grant connect, resource to scott;

这里的scott就是你建表的用户。

之后再登录scott用户下，就可以顺利建表了。

，
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Oracle Java JDBC编程注意事项Next article：重建Oracle的EM

Related articles

See more