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;

CodePudding user response:

reference wmxcn2000 reply: 3/f
system in the execution 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;


Thank you moderator greatly! Got it! This knowledge is in oracle will be in the manual? I go to download a backup

CodePudding user response:

reference 4 floor orsonV response:
thank moderator greatly! Got it! This knowledge is in oracle will be in the manual? I go to download a copy of the standby


If can, you can go to the official documents, Chinese information, you can look at the baidu about the basic knowledge of oracle;

CodePudding user response:

Under the database user
Under the user object, the object has a tables, indexes, views, etc.
If a user wants to query another user under the table, the query of the form has permissions
Access can be used in a user name. The method of object name

Do not add a user name, the default is to query the current user object dictionary tables

CodePudding user response:

System in the implementation of the create table XXX (). ., is this table owner system; You use another user logged in, select * from xx, is a query table; Its own with no this form, so an error;
Well * from system. Table_name to add table in front of the owner

CodePudding user response:

reference wmxcn2000 reply: 3/f
system in the execution 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;


Whether can build synonyms,

CodePudding user response:

No added before each object system. Xx owner, is under this user search by default, if you want to access other user object, is in need to access the object with other user name,

CodePudding user response:

Under the database user object has a lot of, tables, indexes, views, etc.
If a user wants to query another user under the table, the query of the form has permissions
Access can be used in a user name. The method of object name,
Do not add a user name, the default is to query the current user object dictionary tables

CodePudding user response:

SYSTEM is user, table under another user, lookup table to add pattern between different users (user) name
  • Related