admin管理员组文章数量:1619751
Problem
You wish to prevent users, or an errant software application, from inserting values into certain table columns. For example, you wish to allow a program to insert into EMP, but only into the EMPNO, ENAME, and JOB columns.
Solution
Create a view on the table exposing only those columns you wish to expose. Then force all inserts to go through that view.
For example, to create a view exposing the three columns in EMP:
create view new_emps as select empno, ename, job from emp
It is also possible, but perhaps less useful, to insert into an inline view (currently only supported by Oracle):
insert into (select empno, ename, job from emp) values (1, 'Jonathan', 'Editor')
来自 “ ITPUB博客 ” ,链接:http://blog.itpub/23895263/viewspace-681055/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub/23895263/viewspace-681055/
本文标签: RecipeblockingColumnsInserts
版权声明:本文标题:Recipe 4.7. Blocking Inserts to Certain Columns 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1727341484a1109466.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论