How to create functions across a table in the spatial query

1. Create function table space in FXZH table space
Need to query table in 2. The cursor in the table space strongwater
3. In the table space FXZH directly execute SQL: select * from strongwater. St_pptn_r is be able to get the query result, but is unable to read in the function of the table under the strongwater
As shown in figure:

CodePudding user response:

You this is not a table space problem...

This is PL/SQL code calls the permissions and defines permissions problem, try in the as keyword with AUTHID CURRENT_USER,

CodePudding user response:

I don't seem to be very like this, there are two table space

CodePudding user response:

I don't seem to be very like this, there are two table space

CodePudding user response:

FXZH and strongwater were two table space users

CodePudding user response:

If access control are perfect, so it should do is let p01_data_t and st_pptn_r two tables belonging to a user belongs to your function table level user granted permissions:
Grant select on p01_data

reference 4 floor qq_33051685 response:

FXZH and strongwater were two table space user

The powers of the table space that's ok with you, it is problem,

CodePudding user response:

This is not across the table space, but across user (schema)

If you want to query other users in the procedure or function (schema) data, explicit authorization;

Grant select on tname to user1.

CodePudding user response:

Across user permissions, you are in the as keyword with AUTHID CURRENT_USER.

CodePudding user response:

Across user, try with a grant

CodePudding user response:

Across user can use to create synonyms, and then to perform