Home » Developer & Programmer » JDeveloper, Java & XML » Retrieve the project which belongs to logged on user
Retrieve the project which belongs to logged on user [message #416676] Mon, 03 August 2009 20:47 Go to next message
aminah
Messages: 13
Registered: June 2009
Junior Member
hello there..

i'm doing an application to display the projects which only belongs to the logged on user.

the logged on user shouldn't be able to see other users' projects.

i am not quite sure on where to do the SQL statement.

can anyone guide me through this??

thank you(:
Re: Retrieve the project which belongs to logged on user [message #416696 is a reply to message #416676] Tue, 04 August 2009 00:21 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
It depends on how you store your projects.
You could create a view with a where-clause restricting people to their own projects (whatever that may be) and only provide access to that view, instead of to the table.
If you want more information, you will have to give us a picture of your situation first.
Re: Retrieve the project which belongs to logged on user [message #416706 is a reply to message #416696] Tue, 04 August 2009 01:04 Go to previous message
aminah
Messages: 13
Registered: June 2009
Junior Member
oh okok..then how do i create a view and do the access??

i'm not so familiar with JDEveloper
Previous Topic: Display logged in user name
Next Topic: load xml file in oracle table
Goto Forum:
  


Current Time: Sun Dec 28 10:40:42 CST 2014

Total time taken to generate the page: 0.19633 seconds