Current location - Loan Platform Complete Network - Foreign exchange account opening - Is oraclefx foreign exchange reliable?
Is oraclefx foreign exchange reliable?
The table in the view was also downloaded by this user. If the authorization of the table is deleted, the view will not be affected. If there are other users in the table, you need to have the grant option;

sqlplus / as sysdba

Create table t1(number f1);

Create the view v 1 as select * from t1;

Create a user cc identified by wcycc;

Authorized to connect to cc;

Authorize select on v 1 to cc;

Connecting cc/wcycc

select * from sys . v 1;