I've done what Jim suggests below: edit the structre file to remove granted
rights, reassigning the database to PUBLIC, reload structure, reload the
data.
It does take some time, but it is the only clean approach I've seen/used.
One caveat: be sure your tables are created and loaded in PK/FK dependency
order.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Jim Blackburn
> Sent: Tuesday, June 26, 2001 6:13 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Access rights
>
>
> Try using:
> REVOKE ALL PRIVILEGES FROM SIKOC
>
> or, using the Menu options for revoking. One of the options will
> likely work.
>
> You may already have done it.
>
> If you have the owner password, and the database is not in use
> all the time, you can dump the structure to a file, the data to a
> different file, edit the structure, and run the two files.
>
> Hope it helps,
> Jim Blackburn,
> Kodiak
>
> [EMAIL PROTECTED] wrote:
> >
> > I was trying to setup some access rights this morning on a database, and
> > kept running into a problem. A form being run as a menu, attached to a
> > dummy table, had a variable lookup defined in it that pointed to a table
> > that I had not granted select access to my test username. I
> didn't realize
> > that was the problem, and assumed I had forgotten to grant access to the
> > dummy table, so I did. When I listed the access rights for the
> test user,
> > the newly granted access didn't appear.
> > It looked like this:
> >
> > User Password Table Access Column
> > -------------------------------------------
> > KRONT brine_look SELECT
> > SIKOC
> >
> > You notice there isn't anything next to the 2nd user (the test
> user in this
> > case).. I tried adding it a couple of more times to no avail. I tried
> > disconnecting and reconnecting, packing, reloading, etc... Once or twice
> > what would appear would be multiple instances of SIKOC with essentially
> > garbage characters after it.. Now I am back to what is shown above.
>
