Excuse me, how much oracle users under the table, belong to the same table space, why do some table insert tip ora - 01950 for table space without permission, some tables can insert?

CodePudding user response:

Belongs to a table space does not equal to a user, resulting in the insufficient permissions these tables belong to different users,

CodePudding user response:

reference 1st floor Song Ge response:

belongs to a tablespace does not equal to a user, resulting in the insufficient permissions these tables belong to different users,

belong to the same table space under the same user

CodePudding user response:

May access these tables is not the same, whether in fact belong to the same table space has no practical significance, because the table access does not care about it in which table space,

CodePudding user response:

Please try again after fu insert permissions can not

CodePudding user response:

Users can only explain current DML operations on the table without insert permissions, and whether the table in the table space and table and other whether can insert table belonging to the same user it doesn't matter

CodePudding user response:

Table without permission, is it no data, is an empty table?

CodePudding user response:

Belong to the same table space but do not belong to the same user, you can give the table insert syntax is as follows:
Grant select on p_a_Summary to temp_cf
P_a_Summary for table name
Who temp_cf for user name (assign permissions to)

CodePudding user response:

Oracle data pattern is: the user was built on the database instance, table is built on the user
Different database instance can be built the same user;
The same database instance, the user name cannot be the same;
A user can use more than one table space;
A table space can be used by multiple users.
The powers of a table are defined and users binding;
Table space does not involve any access control problem;
Different users can be created with watches on the table space, but can't create synonym for same watches;
The oracle database access control is in the user, role and control between the data object, have nothing to do with the table space;