Retrieve the project which belongs to logged on user [message #416676] |
Mon, 03 August 2009 20:47 |
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 |
Frank
Messages: 7901 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.
|
|
|
|