users & privileges
i know that i can grant a user or a role privileges to
select or update certain columns in a table but can grant
privileges for certain row?
for example, i have a table, lets call it projects and for each
row i save the id of the owner.the id is the same as the users of
the system.i want that the user that log in will be able to see only
the rows that he owns and won't be able to see the other projects
in the table which he doesn't own.
can it be done in the database level or only in application level?
|