Home » SQL & PL/SQL » SQL & PL/SQL » how to GRANT, is it possible???
how to GRANT, is it possible??? [message #201615] Mon, 06 November 2006 01:52 Go to next message
oralover
Messages: 97
Registered: January 2005
Member
hi gurus!

using Database 10g R1, has it feature to grant Column Level permission, (e.g. I have a user A which has a table TT and i want to give update permission on Column XYZ of table TT of user A to user B) if yes, how i do this????

user  A
Table TT
Columns:  ABC varchar2(10),
          DEF varchar2(10),
          XYZ number(4),
          Z   number(4)

user B: 
must have permission to update ONLY column XYZ 


thanks alot in advance.
Re: how to GRANT, is it possible??? [message #201617 is a reply to message #201615] Mon, 06 November 2006 01:57 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can recall, that is not possible. However, you might create a view for User_B which will contain only accessible columns.
Re: how to GRANT, is it possible??? [message #201628 is a reply to message #201617] Mon, 06 November 2006 02:35 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

is this what you are looking for.

 grant update(XYZ) on TT to user B.




regards,
Re: how to GRANT, is it possible??? [message #201633 is a reply to message #201628] Mon, 06 November 2006 02:44 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/450/0/ True! Shame on me ./fa/1604/0/
Re: how to GRANT, is it possible??? [message #201634 is a reply to message #201628] Mon, 06 November 2006 02:52 Go to previous message
oralover
Messages: 97
Registered: January 2005
Member
thank alot alot for very quick response to help me. Razz
much gratefull to you friend.
best regards.
Previous Topic: ora-00022
Next Topic: Bulk collection
Goto Forum:
  


Current Time: Sat Dec 03 08:02:11 CST 2016

Total time taken to generate the page: 0.06587 seconds