Home » RDBMS Server » Security » how can i do this (oracle for 6i,database 9i,windows xp)
how can i do this [message #390852] Tue, 10 March 2009 01:00 Go to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
i have table account
(id number(4),
name char(25))
this table have this data
1,advertising
2,finance
3,bank
i have three user for example (A,B,C)
user A can select ,update,delete on table test for only id 1
but he can not update or delete the rest of data (2,3)

user b can select,update,delete on table test for only id 2
but he can not update or delete the rest of data (1,3)

user b can select,update,delete on table test for only id 3
but he can not update or delete the rest of data (1,2)
Re: how can i do this [message #390853 is a reply to message #390852] Tue, 10 March 2009 01:10 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Virtual private database might be one option.
Re: how can i do this [message #390856 is a reply to message #390852] Tue, 10 March 2009 01:31 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
View and trigger on it are the best option in this simple case.

Regards
Michel
Previous Topic: Howto: Privilegs based on foreign key of a column??
Next Topic: SQL
Goto Forum:
  


Current Time: Thu Mar 28 14:03:21 CDT 2024