log on as sys schema: create role account_managers; create role customer_service; create role sales_reps; grant select on customer to account_managers; grant select on customer to customer_service; grant select on customer to  sales_reps;  

kancha01 · Mar 14, 2009 4:26 PM

Man sometime u need to google it  if u can't do it.This is really bad habit asking ur hw question on this forum. This is such an easy question.Your professor must have taught u.If u didn't listen in class just see here http://www.techonthenet.com/or... You get plenty of information on these things. Please use it. Thx

iluvnepal · Mar 14, 2009 4:27 PM

Thank you very much kancha01 and iluvnepal. i had to hospitalized for a month for surgery and i missed all the lecture . now I have to cover all that I miss which is making me crazy now.thanks for your help,

gsu · Mar 14, 2009 4:46 PM

Kancha01. I did that first 3 code already last 3 code not working. I am not sure why this code doesnt work. grant select on customer to account_managers; grant select on customer to customer_service; grant select on customer to  sales_reps;  

gsu · Mar 14, 2009 4:59 PM

Kancha01. I did that first 3 code already last 3 code not working. I am not sure why this code doesnt work. grant select on customer to account_managers; grant select on customer to customer_service; grant select on customer to  sales_reps;  

gsu · Mar 14, 2009 4:59 PM