Users don't have indexes for one table

[Steve Workings]

Customer is nearly recovered from a virus that shut their company down for 2 days. About 20,30 users all working directly on the server - no shadow, andwe've confirmed no .CDX files on the local workstations.

We have a lot of rights assigned within the A5 application that are based on the network login User Name.

Current status is that everyone's getting in, working with the system just fine with one puzzling exception:

If the user is not logged in as Administrator, then the indexes for one of the tables (a very important one besides) are simply not there.

The Administrator can log in at their work station and all is fine however.

So, why would the indexes for this one table be available only to the Administrator, and not to anyone else? It's only for one table -- index use is normal in all other tables.

Thanks for any ideas.

[DaveM]

Re: Users don't have indexes for one table

is the CDX in the folder on server at all? Since you are not using shadowed, the only copy of the cdx should be on the server.

Have you tried:
rebuilding the indexes from the CP for that table?
checked the security permissions of the table from the CP?

[Steve Workings]

Re: Users don't have indexes for one table

Dave - CDX is there - that's why administrators can use it.

IT is looking at file-level security. It's the same as the other CDX files. Dunno yet.

[DaveM]

Re: Users don't have indexes for one table

Still sounds like a security issue at table level.
Did you open the cp, right click on the table and open the security there?

if so,

delete the cdx file after backup and rebuild it completely - alpha will make a new cdx on start, with nothing in it.

next if that does not work

Full backup first as usual.
May suggest duplicating the table with a new name keeping everything.
then delete the old one and rename the new one.

[Steve Workings]

Re: Users don't have indexes for one table

Solved. Dave, you and Al (through PM) focusing on the rights issue helped me push that with their IT dept.

But, the rights problem was not on the CDX. It was on the DDD and DDX. Fixed, everyone's back to work.

Thanks.

[Al Buchholz]

Re: Users don't have indexes for one table

Solved. Dave, you and Al (through PM) focusing on the rights issue helped me push that with their IT dept.

But, the rights problem was not on the CDX. It was on the DDD and DDX. Fixed, everyone's back to work.

Thanks.

Strange that other objects were not affected... Forms/browse/report - even if they were based on a set that used the table..

Good to know and add this to the list of stuff to look for.

[DaveM]

Re: Users don't have indexes for one table

Steve,
Can you clarify if it was a setting on the server or a setting within alpha on the server?
It may affect others at some point.

Agree with Al, should have affected more.

[Steve Workings]

Re: Users don't have indexes for one table

Well, we don't have any forms which are based just on that table, but a lot of forms on sets that use that table. Those forms threw trace errors, showed "error" in the fields, etc. which prompted my thought to the .DD* files.

This was a tough one to fix -- lots of damage in a variety of ways and places. It's the "Locky" ransomware if you're interested. I wouldn't put much of our lessons into any "standard" inventory list when things go wrong, but perhaps if malware hits it's a higher priority.

[Al Buchholz]

Re: Users don't have indexes for one table

Well, we don't have any forms which are based just on that table, but a lot of forms on sets that use that table. Those forms threw trace errors, showed "error" in the fields, etc. which prompted my thought to the .DD* files.

This was a tough one to fix -- lots of damage in a variety of ways and places. It's the "Locky" ransomware if you're interested. I wouldn't put much of our lessons into any "standard" inventory list when things go wrong, but perhaps if malware hits it's a higher priority.

That makes more sense... Let us know how you get rid of it.

I see there are some removal tools.

[Steve Workings]

Re: Users don't have indexes for one table

The company has an IT department, so I didn't get saddled with that job. But I have a couple desktops available to me for what I do, and I see a new shortcut for Malwarebytes Anti-Malware.

Lots of files brought in from backups as well, so a good backup plan with a current backup was very helpful.