admin管理员组

文章数量:1558091

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://m.elefans.com/dongtai/1727341484a1109466.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。