Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 31st, 2006, 01:02 PM
Registered User
 
Join Date: Oct 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?

 
Old November 8th, 2006, 04:50 PM
Registered User
 
Join Date: Nov 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You could create a VIEW (virtual table) based on the table, WHERE ID = USER. USER is the Oracle session userid of the person logged on. This should work, in which case the solution is at the database level (as the view) which is always preferable to dealing with things like this at the application level.




Similar Threads
Thread Thread Starter Forum Replies Last Post
restarting MySQL service resets all my privileges crmpicco MySQL 0 January 27th, 2006 11:33 AM
Linux & KDE & C++ & QT & MYSQL & Kdevelop Munnnki Linux 0 January 2nd, 2005 05:41 PM
User/Role Privileges mike123abc SQL Server 2000 1 July 7th, 2004 03:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.