Re: Error adding permissions and database users

The DDF's definitely seem to be messed up. We've found that one old
DDF builder application used to create DDF's and supply the Btrieve
File name of "X$File.DDF" for X$File -- although the CORRECT Btrieve
File name is actually FILE.DDF. You can confirm this by running this
command "BUTIL -SAVE FILE.DDF FILE.UNF N 0" from the command line (with
security NOT enabled). The first line item should show FILE.DDF -- if
it doesn't, then you have problems. The others should be FIELD.DDF and
INDEX.DDF, of course.

Another possible problem is the use of varying directory paths in your
DBName, and it is finding multiple DDF files, but this is less likely
an issue.

Your best bet is to fix the DDF's, although this may need to be done
manually by changing the records within the DDF's themselves. You can
do this with the Function Executor if you know the file's owner name.

We can also provide a service to review and rebuild the DDF's, if
needed. If it is this problem as we suspect, then the cost will be
only $50.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***

Dave wrote:

> Hi all,
>
> Pervasive 8.7 on Netware.
>
> I've configured a Named Database.
> I've then enabled database security by setting a master password for
> that database.
> > From PCC i can see all the tables, and open the tables and see the
> data.
> When I try and add a new database user, I get the following error:
>
> [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine
> Interface][Data Record Manager]No such table or object.
>
> However, the user is actually created.
> But, when i go back into the user to then give the user some
> permissions to the tables, I get exactly the same error again when i
> try and save.
>
> Has anyone got any ideas? I'm stuck. If I'd stuffed up the DDF path,
> etc, then I wouldn't be able to view the tables.. so I'm not sure
> where i've gone wrong.
>
> Thanks
> Dave

.