Home » RDBMS Server » Server Administration » Query/Insert in a view
Query/Insert in a view [message #371690] Sun, 26 November 2000 23:36 Go to next message
sunil gupta
Messages: 11
Registered: September 2000
Junior Member
Can anybody help me with this :
Lets say I create a view v_emp as select * from emp where deptno >10. Then while querying I get only records where deptno is greater than 10 but at the same time I can insert in view records having deptno equal to 10. So how do I prevent users from inserting record with deptno=10.

thanx in advance.
Sunil

Report message to a moderator

Re: Query/Insert in a view [message #371707 is a reply to message #371690] Mon, 27 November 2000 18:31 Go to previous message
Sudheer
Messages: 19
Registered: July 1999
Junior Member
While creating View use with check option..I think that will help u ....

All the best
Sudheer

Report message to a moderator

Previous Topic: SQL Command that returns only certain rows
Next Topic: reading text file(csv) into a database table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 02:11:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.