Hello

EDB 2.02.15 and D2009

my problem:
i have to Databases in the programm folder of the application.
These folders are readonly (like all data in the programs path).
These databases are readonly data for the application. (There will no
be changes from User). If i set the attributes on EDBDatabase.EDBCat
and the datafiles to readonly there is no problem, but the installer
that is used dont do it allways correct. I have no way to change these
because i'm a external developer to the application and i can't change
the rules

Now my question: Can i trap the Error in Delphi and bring the Database
in a readonly mode like it works with attribute readonly on filebase?

Thanks

Fritz

Friedrich,

<< Now my question: Can i trap the Error in Delphi and bring the Database in
a readonly mode like it works with attribute readonly on filebase? >>

The only way to do so at this time would be to set up the user security for
the users/roles in such a way that their access is read-only.  There really
isn't any way to do so at the OS level short of changing the attributes.

I assume that you're using MS Vista for the OS ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> The only way to do so at this time would be to set up the user
> security for the users/roles in such a way that their access is
> read-only.  There really isn't any way to do so at the OS level short
> of changing the attributes.
>
> I assume that you're using MS Vista for the OS ?

Hello Tim,

Yes the problem is Vista,
so if i do


GRANT SELECT
ON DATABASE "Texture"
TO "CWUSERS"

And have a User pointing only to these Role it shoud work?

I will give them a try.
Thanks for your help

Friedrich

Friedrich,

<< Yes the problem is Vista, >>

Grrr.

<< so if i do

GRANT SELECT
ON DATABASE "Texture"
TO "CWUSERS"

And have a User pointing only to these Role it shoud work? >>

Yes, but you'll also have to make sure that:

1) That role (CWUSERS) is granted the SELECT privilege on all tables that
you wish to have them access in the Texture database,

and

2) That the Public role has its default privileges scaled back, otherwise
the users will still be able to edit the database.  You don't want to revoke
the Public role from each user, though, because that will prevent them from
being able to see the system-defined Configuration database, which could
cause errors in your application if you try to query the Configuration
database while they are logged in.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

I have tried it, but without setting the readonly attribute for the
*.EDBlck, *.EDBCat... there is now way to use it properly.

I think a "readonly" Session or Database thats act like all files in a
Database-Folder are readonly are the better way

can you put it on your list of suggestions?

Thanky for your help and great work

Friedrich

Friedrich,

<< I have tried it, but without setting the readonly attribute for the
*.EDBlck, *.EDBCat... there is now way to use it properly. >>

I'm not quite sure what you mean.  Are you saying that using the user
security method doesn't work ?  If so, in what way is it not working ?

<< I think a "readonly" Session or Database thats act like all files in a
Database-Folder are readonly are the better way

can you put it on your list of suggestions? >>

It's already there - Igor Colovic requested it a while ago for databases and
tables.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

Hello Tim


> I'm not quite sure what you mean.  Are you saying that using the user
> security method doesn't work ?  If so, in what way is it not working ?

i send you a mail to support  with printscreen from errormessages,
catalog and Database folder

If i set all files in the db-folder readonly it works.


Greetings
Fritz

Friedrich,

<< i send you a mail to support  with printscreen from errormessages,
catalog and Database folder

If i set all files in the db-folder readonly it works. >>

An "Access denied" error message from the operating system means that the
current user doesn't have the proper rights to open the file in a read-write
or read-only fashion.

Did you double-check the user rights for that folder ?  Also, who are you
logged in as on the Vista machine ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

Hello Tim,

The folder has the default user rights from Vista for the
programm-files dir. That means readonly access. I was trying the accees
logged in as Normal User and as Adminitrator (only logged in). Always
the same result. If i grant the rigths for modify to the DB-Path (in
Vista) it works. Or if i set all edb-files readonly it works also.

But for the moment we have fixed it, the installer will set the
permissions for modify to the DB-Path.

We will see.......


But i think have a option for a readonly database would realy be nice.


Thanks
Fritz


> An "Access denied" error message from the operating system means that
> the current user doesn't have the proper rights to open the file in a
> read-write or read-only fashion.
>
> Did you double-check the user rights for that folder ?  Also, who are
> you logged in as on the Vista machine ?

Friedrich,

<< The folder has the default user rights from Vista for the programm-files
dir. That means readonly access. I was trying the accees logged in as Normal
User and as Adminitrator (only logged in). Always the same result. If i
grant the rigths for modify to the DB-Path (in Vista) it works. Or if i set
all edb-files readonly it works also. >>

Something is wrong, then.  EDB should automatically back off to read-only if
it cannot open any of the files in read-write mode.  I'll check it out.

--
Tim Young
Elevate Software
www.elevatesoft.com