Oracle data query, do not add sid prefix data query out what reason be?
The following, I use the select * from student query data is empty, if I add a prefix the select * from MYSID. The student can query the data? Is this why?

CodePudding user response:

Users, MYSID
Is a sign that you are currently logged in user is not MYSID,
This statement can view your current logged in user
Select the user from dual;

CodePudding user response:

- this look not to come out?
Select * from student
- and this can be found out,
Select * from MYSID. Student


Shows that you currently not with MYID login, and the current user, there is also a student the form, the structure of the two tables should be the same,

CodePudding user response:

Is likely to be said on the second floor of the reason, but also may be because of permissions,

CodePudding user response:

Couldn't not MYID inquiries, user data, possible permissions