[SQL] Permissions on tables

2005-03-26 Thread subhash
Hi, I have a requirement where I have a table and a view on top of it. I want to make some changes so that a user in a given group would be able to insert/update only on the view (ofcourse i have a rule which inserts/updates the table) but not on the underlying table. I tried revoke the insert/upda

Re: [SQL] Permissions on tables and views

2005-03-22 Thread Michael Fuhr
On Tue, Mar 22, 2005 at 02:28:08PM -0700, [EMAIL PROTECTED] wrote: > I have a requirement where I have a table and a view on top of it. I want to > make some changes so that a user in a given group would be able to > insert/update > only on the view (ofcourse i have a rule which inserts/updates t

[SQL] Permissions on tables and views

2005-03-22 Thread subhash
Hi, I have a requirement where I have a table and a view on top of it. I want to make some changes so that a user in a given group would be able to insert/update only on the view (ofcourse i have a rule which inserts/updates the table) but not on the underlying table. I tried revoke the insert/upda