---赋予system用户,创建和查询权限了 grant create,select on any table to user;
你先看下你建的用户有些什么表:SELECT * FROM dba_tables WHERE owner=&user; 再给权限给你建的用户: grant RESOURCE to &user; 上面这两步是在system下完成. 然后连进你建的用户,应该就能看到你建的表了
The upper floor is completely correct. When you create a user under the system schema. You must grant some roles with special privileges to the user. For example: --Under the system, you create a new user. create user newuser identified by newuser;--grant the connect and resources to the user. grant connect, resources to newuser;In this way, you could see the objects in the newuser schema.
grant dba to user;
user 为你自己的用户名;
grant create,select on any table to user;
再给权限给你建的用户: grant RESOURCE to &user;
上面这两步是在system下完成.
然后连进你建的用户,应该就能看到你建的表了
When you create a user under the system schema. You must grant some roles with special privileges to the user.
For example:
--Under the system, you create a new user.
create user newuser identified by newuser;--grant the connect and resources to the user.
grant connect, resources to newuser;In this way, you could see the objects in the newuser schema.
=================================
可以看到这个用户自己建立的表,当然这个用户要有 create table 权限。这个用户要看到别人的表,要由管理员或表的拥有者用户给这个用户相应的权限。
如果是使用本用户,要在PLSQL中看到其他用户的表,那么需要建立到其他用户表的同义词。
2.没有resource权限
as normal 和 as sysdba是不一样的.