471,092 Members | 1,519 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

restrict user's view

hi,
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
Jul 19 '05 #1
1 2012
tr********@yahoo.com.hk (tracy) wrote in message news:<5c*************************@posting.google.c om>...
hi,
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

Just define a view ending in
where programmetype = 1
with check option
and grant access to the view.
The view can have the same name as the original table.

That is all.

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by ManishShukla_atforum | last post: by
1 post views Thread by tracy | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.