Bug?: SYSDBA Network Read-only not working

Business edition tips, tricks, problems and discussions

Moderators: Max, TerryRogers

Post Reply
MetalDrop
Guru
Posts: 864
Joined: Sat Apr 09, 2016 10:19 pm
Been thanked: 189 times

Bug?: SYSDBA Network Read-only not working

Post by MetalDrop »

Not sure if this is a bug or by design.

When logged into a network database as SYSDBA read-only doesn't work.
- The read only icon is grayed out and read-only appears to have zero effect.
EPIM Portable Pro Running/Tested On: Windows 11 Pro 64-bit US-ENG|i5-6400+Quadro P620|i7-7700K+1050ti|i7-8700K+970GTX|AMD 5600x+1080ti|16GB+RAM&NVMe SSDs
[I'm helpful and often reply to questions, however I am just a fellow user and not staff.]
admin
Site Admin
Posts: 12537
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1124 times
Been thanked: 777 times

Re: Bug?: SYSDBA Network Read-only not working

Post by admin »

I'm unable to reproduce this. Which type of data are we talking about? Was that a regular user who marked an item as read-only?
Android version of EssentialPIM. Keep all your data in sync!
S_Belle
Guru
Posts: 170
Joined: Sun Sep 15, 2019 4:54 pm
Been thanked: 4 times

Re: Bug?: SYSDBA Network Read-only not working

Post by S_Belle »

I can reproduce this.

I only use the SYSDBA user on my network database since I'm the only users, and can confirm that read-only doesn't work with the SYSDBA account.

Since I don't use any normal users obviously all items I tested were created by and marked as read-only by the SYSDBA account, and SYSDBA can still write to the notes it's marked as read-only.
Attachments
Read-only Not Work.mp4
(167.48 KiB) Downloaded 60 times
admin
Site Admin
Posts: 12537
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1124 times
Been thanked: 777 times

Re: Bug?: SYSDBA Network Read-only not working

Post by admin »

I think this issue might be database-dependant. Please create a new one and see if the problem will be reproducible with it. If so, forward me the db. Thanks!
Android version of EssentialPIM. Keep all your data in sync!
MetalDrop
Guru
Posts: 864
Joined: Sat Apr 09, 2016 10:19 pm
Been thanked: 189 times

Re: Bug?: SYSDBA Network Read-only not working

Post by MetalDrop »

I made a new database and it worked fine, then I thought about favorites breaking in the beta when the database got above 1,000 notes.

So I duplicated a note to over 1,000 and tried again and sure enough read-only was broken with SYSDBA again.

So much like the favorites issue this one seems to be related to something that breaks after the database gets some number of note entries.

I've attached a database with a bunch of blank notes and one note that is marked as read-only that can be edited when logged in as SYSDBA on a network.
Attachments
NTtest.zip
(1.01 MiB) Downloaded 62 times
EPIM Portable Pro Running/Tested On: Windows 11 Pro 64-bit US-ENG|i5-6400+Quadro P620|i7-7700K+1050ti|i7-8700K+970GTX|AMD 5600x+1080ti|16GB+RAM&NVMe SSDs
[I'm helpful and often reply to questions, however I am just a fellow user and not staff.]
admin
Site Admin
Posts: 12537
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1124 times
Been thanked: 777 times

Re: Bug?: SYSDBA Network Read-only not working

Post by admin »

This is by design. In Business edition you mark an item as read-only for other users, not for yourself. We will fix the inconsistency described in you last post. Thanks!
Android version of EssentialPIM. Keep all your data in sync!
Post Reply