开发者

Oracle view and grant question

开发者 https://www.devze.com 2023-03-23 05:31 出处:网络
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?

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

精彩评论

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