Home > database > Why the system create table system, the average user authorization can't see?
Why the system create table system, the average user authorization can't see?
Time:09-24
First is the table of the CDB zhongjian,
I use the system in the last build the table, and then to the general user authorization can look at the table, commit,
But use ordinary users connect to the database, and then to query the table, will tip: table or view does not exist,
To return to use the system login, query the table, just check the,
This is how to return a responsibility? Please answer!!!!!!
CodePudding user response:
but use ordinary users connect to the database, and then to query the table, will tip: table or view does not exist,
Select * from system. Table_name
CodePudding user response:
Successful, boots boots! But why access system built by the need to add this table? I'm just in the university learn oracle, understanding ~ please predecessors
CodePudding user response:
System in the implementation of the create table XXX (). ., is this table owner system;
Another user logged in, select * from xx, is a query table; But without this form, so an error;