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.
