Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 12 total |
setting a Database readonly |
Thu, Aug 6 2009 3:15 AM | Permanent Link |
"Friedrich Westermann" | 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 |
Thu, Aug 6 2009 11:04 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Aug 6 2009 11:27 AM | Permanent Link |
"Friedrich Westermann" | 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 |
Thu, Aug 6 2009 2:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Aug 7 2009 3:35 AM | Permanent Link |
"Friedrich Westermann" | 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 |
Mon, Aug 10 2009 2:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Aug 11 2009 2:29 AM | Permanent Link |
"Friedrich Westermann" | 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 |
Tue, Aug 11 2009 4:52 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Aug 12 2009 4:53 AM | Permanent Link |
"Friedrich Westermann" | 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 ? |
Thu, Aug 13 2009 11:12 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |