Re: Error adding permissions and database users

Ok found that problem --- there was a FILE.DDF and a FIELD.DDF in the
same directory as the data files. I renamed those, and now I can open
the X$Files table.

However, I still get the table not found error when adding permissions.

I noticed X$Rights does not exist.

So, I performed a GRANT statement and that has generated X$Rights.

If I view the user in PCC, the select permission on that table shows
up. But, if I try and make any changes from the PCC, it errors with
table not found.

Any ideas on why this is happening? And, why a GRANT SELECT ON *
doesn't work?

cheers
Dave

.