oracle数据库运行SQL文件提示没有表空间权限时怎么办

 

运行

SQL>grant resource to system;
SQL>grant resource to jilin;
SQL>grant resource to liren;
SQL>ALTER USER "SYSTEM" QUOTA UNLIMITED ON "USERS"; 
SQL>ALTER USER "SYSTEM" QUOTA UNLIMITED ON "JILIN"; 
SQL>ALTER USER "SYSTEM" QUOTA UNLIMITED ON "LIREN";

赋予权限