| grants [message #205394] |
Fri, 24 November 2006 08:36  |
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  |
skooman
Messages: 913
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 #205423 is a reply to message #205412] |
Fri, 24 November 2006 11:52 |
 |
Littlefoot
Messages: 21823
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
