Re: restrict access for an user doesn't work

On Fri, 11 Jun 1999, georges Chaleunsinh wrote: > hi, > > i read in comp.databases.informix i can restrict access for one user. > i need to grant connect first. then revoke all and finally grant select > to the specifics tables. > But i doesn't work!! > > for example: suppose i want restrict to the user toto on the table > webusers with only select. > > grant connect to toto; > revoke all on webusers from toto; > grant select on webusers to toto;> > Could Somebody tell me what's wrong with this? > > > Have you revoked all on webusers from public? The generic user *public* superseeds all grants to specific users. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-4123 Colorado State University Pager: (970) 229-8173 Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu ====================================================================