Home » SQL & PL/SQL » SQL & PL/SQL » grants
grants [message #205394] Fri, 24 November 2006 08:36 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
Hello folks,
I'm using Oracle 9i.
I know that one user can grant the privilege "SELECT ON TABELE_NAME" to another.
My question is: How can one user grant a SELECT ON A TABLE COLUMN to another? Is this possible ?
Thanks for any help.

Re: grants [message #205407 is a reply to message #205394] Fri, 24 November 2006 10:04 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
If you mean: there is a table (T1) with 4 columns (say C1, C2, C3 and C4) and you only want the other user to be able to select columns C3 and C4?

If so, I haven't heard of any grant option that does this. However, if it's important that the user can not select from C1 and C2, just create a view as select C3, C4 from T1 and grant select on that view to that user (and not on T1 itself).
Re: grants [message #205412 is a reply to message #205407] Fri, 24 November 2006 10:23 Go to previous messageGo to next message
Upperm
Messages: 95
Registered: July 2003
Member
Yes dear Skooman, your answer is exactly what I meant.
Thanks a lot.
Re: grants [message #205423 is a reply to message #205412] Fri, 24 November 2006 11:52 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I know you didn't ask that, but nevertheless: as long as it is impossible to GRANT SELECT on a particular column, you could GRANT UPDATE or INSERT on a column using this syntax (Oracle 10g; I'm not sure about earlier versions):

GRANT UPDATE (column_name) ON table_name TO another_user;
Previous Topic: DBMS ERROR LOG giving error,plz help
Next Topic: need help with converting unix timestamp column
Goto Forum:
  


Current Time: Thu Dec 08 00:34:53 CST 2016

Total time taken to generate the page: 0.15705 seconds