question on VIEWS

I'm using views (or trying to) for the first time. I want the table to have permissions set to select only for public. Then I want one view that allows select and insert on all columns and another view that allows 'all' on a subset of those columns. I created the table first and revoked all permissions from public. Then I created each view with the columns I wanted and granted the appropriate permissions. I checked the permissions and they look fine. Then I logged on as another user and tried to update some data in the table (not a view) and it let me. What am I doing wrong? The user I logged on as is not a special user. They only have 'Connect' priveledges on the database. Help would really be appreciated. Sent via Deja.com http://www.deja.com/ Before you buy.

jbcamel@mediaone.net wrote: > > I'm using views (or trying to) for the first time. > > I want the table to have permissions set to select only for public. > Then I want one view that allows select and insert on all columns and > another view that allows 'all' on a subset of those columns. > > I created the table first and revoked all permissions from public. > > Then I created each view with the columns I wanted and granted the > appropriate permissions. > > I checked the permissions and they look fine. > > Then I logged on as another user and tried to update some data in the > table (not a view) and it let me. > > What am I doing wrong? > > The user I logged on as is not a special user. They only have 'Connect' > priveledges on the database. Does this user have its own permissions on the table itself? What are the table and column level permissions for the view and the underlying table? SELECT * FROM systabauth WHERE tabid = ... SELECT * FROM syscolauth WHERE tabid = ... Art S. Kagel