I have a table name stud_info where we stored student's information.
This is a sharing screen for Undergraduate department and Post
graduate department.
To differential a student type either in Undergraduate or Post
graduate is using programme type; 1 is for Undergraduate and 2 for
Post graduate ;
Now, i want to restrict example, Undergraduate department to view,
select,update,delete only student Undergraduate's data, same to Post
graduate department where they only allow to view the Post graduate
data.
Can somebody provide me instruction and PL/SQL how to do this.
thank you very much