Home > database >  Oracle limit query problem
Oracle limit query problem

Time:10-14

Can I use oracle to build a simple course selection system how to let users can only view their information? For example, there are three users, administrators, teachers, students, administrators built student information table, how should I make the login user can only see students information inside their own, others can't see?

CodePudding user response:

Grant's words can only give to view a list of permissions, you can specify a particular line

CodePudding user response:

Oracle's rights management to someone cell line (at a specific attribute), specific how to do the search on the net

CodePudding user response:

You this requirement, it is designed in the program, for example you DB set a schedule, there is a student ID, your program (such as PHP) according to the user ID you logged in to check the curriculum information returns, the very good implementation in program!

CodePudding user response:

refer to the second floor weixin_40290083 response:
oracle permissions management to someone cell line (at a specific attribute), specific how to do the search on the net
hard to find, so I'm looking for the next

CodePudding user response:

Web project typically record user id when login into the session, it can be taken in the program, when a user query, out from under the session id for the query
  • Related