开发者

Oracle view and grant question

How can I use grant and creation of a view to allow a user to have read only access to certain columns in a table but also be allowed to update only one of the columns?

Can you specify a specific column o开发者_Go百科nly for update on a grant?


So let's say we have a table T with col1...col5 and the user U, he should not see col5 () view needed) and should update col3 (no view needed):

CREATE VIEW V AS SELECT col1, col2, col3, col4 FROM T;

GRANT SELECT, UPDATE (col3) ON V TO U;

see http://www.oracle-dba-online.com/sql/grant_and_revoke_privileges.htm

EDIT: corrected a mistake...

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜